Data Entry Form Inputting to Correct record

[bevc]

I really hope someone can help me, because I feel like I'm going crazy!

I have a button on my 'customer' form that opens a pop-up subform to input information into my 'invoices' (or 'orders') sub-table. I want the sub-form to be for new information only, so in the property sheet I set it to 'data entry', and with the add button wizard I nominated to 'find specific data to display' and related the correct ID fields and such.

But, when I open the form, it doesn't designate new data entry as related to the currently open record, and I'm not sure why. It just opens the form for ANY new invoices, not customer specific.

If anyone could help I'd be very grateful.

 

[pbaldy]

I assume you mean a pop-up form? If it will always be opened from the same form, you can set the default value property of the customer textbox on the pop-up form to a reference to the customer on the first form. An actual subform would be customer specific, presuming the master/child links were set appropriately.

 

[Alex2015]

I assume you mean a pop-up form? If it will always be opened from the same form, you can set the default value property of the customer textbox on the pop-up form to a reference to the customer on the first form. An actual subform would be customer specific, presuming the master/child links were set appropriately.

I think I may have a similar issue. I made sure the master/child links were correct (in my case, EmpID) between the parent form & subform. What I want to do in a data entry form is to select the area where the employee works in the parent form & have that locale automatically fill in the same field in the subform (no matter how many new records the end user makes in the subform). Is this possible w/o VBA?