SubForms talking to the same table as main form

[FishCop]

Hello all,

I am putting together a data entry form to input data into a Landings table.
The aim is for the user to be able to put in several records for different vessels and landed weights but with some values staying the same e.g. Date and Officer Name.

I Made a main form with the text boxes/combo boxes for name and date etc with the Landings Table as the control source - the idea is that the user enters these once. Then added a sub-form for users to enter vessels and landed weights - so several records are made but with the values from the main form being automatically entered each time they enter data in the sub-form.

It inputs all the data as i wanted but... It always adds a record before the user adds any data in the sub-form i.e. a record with just the officer name and date.

I have added a line of code that removes the record as a work around but i get the feeling im forcing Access to do something it doesn't want to - it makes me feel a bit uncomfortable to be honest.

I would be grateful for any thoughts on what I'm doing wrong,

Kind regards,

Luke

 

[JHB]

Post a stripped version of your database with some sample data (zip it) + info name of the form.