update default value in form

[leah7au]

Hi All
This question is probably quite simple but i cant seem to work out the syntax.


I have a customer details form for entering new data into the customer table. I want to be able to add the record to the table and when you click add extra details it opens a new form for adding the extra details assiciated with the customer. I can do all of the above but I would like the new form to have the customer that was just entered as the defualt value on the new form. The customer ID is the primary key in the customer table and I would like to carry the customer id into the new form as the default value to add the extra details instead of having to scroll through to selct the customer from a drop down box

thankx in advance

[RuralGuy]

How about using the WhereCondition argument of the OpenForm command to put a filter on the next form?

[leah7au]

would that be a macro on the openForm event. I am having a problem with the syntax refering to the forms i.e me.fieldName = openFormaname.fieldname.value

[RuralGuy]

You need to add a WhereCondition to the macro that is opening the new form. Do you know how to look at that macro? Can you modify it?