John, I had used the change event because the job ID is an autonumber so the event would only fire once, I believe. Regardless, I changed it to afterupdate(for good habits). However, the code you provided did not solve my problem. The jobs form is opened from a button in the customers form. The jobs form does not contain the field Client_ID(it is only used to sort the jobs under each client). Here I see all the jobs for the selected client. When I enter a new job I would like the form to notice the specific Client_ID selected in the parent form and write this into the Client_ID field in the Jobs Table. Hopefully this information can help further explain my problem.
Thanks, Chad --- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > Chad- > > Why use the Change event? That fires with each character typed in Job_ID. > Consider using AfterUpdate instead. Where is the Client_ID value - in > another form? If so, the syntax should be more like: > > Me.Client_ID = Forms!frmCustomers!Client_ID > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/