button to open form new record

[Fugan]

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

 

[le888]

Is this what you want?

Le

 

[Fugan]

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

 

[le888]

not quit sure what you want. Can you give me an example?

Le

 

[GailFialho]

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"