I can't enter data into a subform

[MichealShinn]

Guys,



Hi. Thanks for your help.

I haven't used subforms before, and I'm missing something here. I have a table named Customers. One customer can have more than one account number. I have a second table named Account Numbers. I've set up a one-to-many relationship with Referential Integrity enforced. I created a form to enter new Customers and another form to enter account numbers. I put the Account Numbers form onto the data entry form for new customers as a subform. When people are just browsing, they can see the Customers and the Account Numbers that that Customer has, but when somebody is entering a new Customer, they can't get into the Account Numbers subform to enter Account Numbers.

I'm obviously missing a crucial step here. Does anybody know what it is?

Thanks again for your help.

Micheal

[John_G]

Hi -

What's happening is that if there are no existing account records for a customer, then the subform will be blank - not even a blank record. What you have to do in this case is change the properties of the subform to Dataentry = Yes.

If new_customer then
me!SubformControl.Form.Dataentry = True
endif

new_customer is whatever criteria you use to determine when data for a new customer is being added.

Notice that in me!SubformControl.Form.Dataentry you don't use the name of the subform - you use the name of the control that contains the subform.

HTH

John

[MichealShinn]

John,

Thanks for your reply.

I already have Data Entry = Y in the properties of both the main form and the subform. Where do I put the code to check to see if the main form has data for a new record in it?

Thanks.

[John_G]

Check the Allow Additions property - it has to be set True as well.

John

[MichealShinn]

That did it. Thank you very much.