dummy records added in the table - Form opening/querying

[senthilmuruganv]

Hi all,

My main form is opened and based on the in put of the main form and the subform is opened. Everything is fine. But, the main form's inputs are created dummy records in one of the table.

Sceneariou: Main form : Inputs : Sample Id and collection date: (both are populated from one table - say "Test") Inputs may be abc, 12/1/11

Based on this input subform is populated and retrieve the expected result.

But, in Test table, new record will be created with sample id as abc and collection date as 12/1/11 and remaining columns are Blank"

Please advise me how to avoid this dummy record in this table.

Thanks!

 

[dhookom]

If you don't want a record added then remove the Record Source from the main form.

Duane
Hook'D on Access
MS Access MVP