Sub Form Quirk!

[Bob Vance]

I have a subform on my form that is used to put additional charges to my
client
If I start my database from empty and then try to create a charge when I
open my form my sub form is just all grayed out no text boxes or controls,
but I delete all my records and just leave 1 record in my data base it will
open up as its meant too!
is there something I can check to see if I am missing something

 

[Wayne-I-M]

Hi Bob

Its a bit like having a shop with shelves. Without the shop the can't be
any shelves or they would have no where to go. Hope that makes sense.

Your subform is dependant on the main form.

You have a main form with someones details on and you have a subform showing
other details about that person. Unless you have the person you can't have
an other details.

There is a relationship between the subform and the main form as they are
join by a common field. Your subform will "look" for this data (to provide a
filter) on the main form. If its not there then the subform will be blank.

Hope all this makes just a little sense.