Fill in 'Add new record'

[GrantD]

Help please,
I have a members table & form, as well as a response table & form. When I click to see the response form I can see all the responses a particular individual had made. When I click on ‘add new record’ (which should add an autonumber to the response table and the members unique id number as well as the drop down choice of response) I cannot get Access to fill in the members id number automatically as I would only be looking at 1 members records at a time.The autonumber fills in fine. I am using a text box in the form design for this.

I’m not very good with VB code yet, so if there is a way to do this using the textbox properties, it will be easier for me.
Thanks

 

[DW]

How is your form designed.

You perhaps need to look at creating the main form from "Members" with an Autonumber field called [ID] then create a Subform from the table "response".

In the Response create a field called [ID] and set the property to numeric long.

With the main form in design view, highlite the subform and set the following properties.

Master: ID
Child: ID

With this all set, when you create a new record, a new record will be created in the subform aswell.

You can still have your lookup combo in the subform also.

Dave

 

[GrantD]

Thanks very much, I'll try and let you know.