button to open form new record

Fugan

Registered User.
Local time
Today, 17:18
Joined
Aug 7, 2006
Messages
16
hello everyone,
i have 2 tables have Relationships with each other and i have a form with a listbox and has the surnames from table1 in it
i want a button to open the job information form on new record and i want it to have the client number in it all ready if i click on one of the surnames from the listbox
tables names
tbl Client Detials = have clients information
tbl job information = has job information
both have client number feild and have Relationship

form i want the button on is called frm client splash and the form i want it
to open is frm job information
its hard to tell u srry i hope someone can help me
________________
David
 

Attachments

nope but ty for trying all i want is if i click on one of them names in list box and click a button to open form "job information" make new record and put the clients number there all ready on the job information form
ty for trying to help
______________
david
 
not quit sure what you want. Can you give me an example?

Le
 
frmSplash:button: "New Job"
OnClick
DoCmd.openForm "frmJobInfo" ,,,,acFormAdd
Forms!frmJobInfo!ClientNumber = me!ClientNumber
<You can assign values to any of the other fields on frmJobInfo here>
DoCmd.close acForm, "frmSplash"
 

Users who are viewing this thread

Back
Top Bottom