I am trying to have a form automatically enter the Client_ID into the
jobs form when a new job is created under a certain customer, the code
below is how I set it up to do so, but it has not worked. Any clue how
to fix this issue?

Private Sub Job_ID_Change()
    Jobs.Client_ID = Customers.Client_ID
End Sub


Thanks
~Chad

PS  Thanks John on the tip of calculating in a table, I re-arranged my
data to fit the preferred method.







------------------------ 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/
 


Reply via email to