Data entry using blank form?

[andrefrancis]

I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere.

What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record.

I have Tables A and B in a 1-to-many relationship and I need to be able to bring up a blank form which has:

1. a combo box, allowing me to select the relevant record from the parent (table A), and ...
2. blank fields (from the child - table B) to fill in with new data.

I can set this up using a standard setup, where all records are shown, but this is confusing to a dumb user, who really only wants to see relevant boxes for them to fill in without the distractions of data in fields they are not concerned with or with other records they do not want to know about.

Can anyone help?

 

[ColinEssex]

set the DataEntry property of the form to "Yes"

Col

 

[andrefrancis]

set the DataEntry property of the form to "Yes"

Col

Yes, thanks Col ... this seems to be most of the way to what I want to do.

Isn't it so easy when you know how!