Blank Subform

E

Emma

I have a form with a subform which holds all the loans a client has. How do I
get the information for the first Loan for that client ID to populate the
subform? Right now it's just showing a blank form which needs one field to be
filled in to get Loan ID. The loan ID is a unique index.
 
J

John W. Vinson

I have a form with a subform which holds all the loans a client has. How do I
get the information for the first Loan for that client ID to populate the
subform? Right now it's just showing a blank form which needs one field to be
filled in to get Loan ID. The loan ID is a unique index.
Click to expand...

What's the datatype of the loan ID? The field in your table might *have* a
unique Index assigned to it, but an index is not a field!

If the unique ID is an autonumber, it need not (probably should not!) be
displayed on the subform at all; it will increment automatically as soon as
you "dirty" the subform by adding data to any other field. If it's not an
Autonumber you'll need some VBA code to populate it, perhaps in the subform's
AfterInsert event. More details please!
 
E

Emma

When I run the form wizard, sometimes it asks me for the subform other times
it doesn't why is this?
 
J

John W. Vinson

When I run the form wizard, sometimes it asks me for the subform other times
it doesn't why is this?
Click to expand...

You'ld have to ask the Microsoft programmers. Why not just create your own
subform? Sometimes the wizards aren't very bright!
 
Top