How do you load up a blank form linked to query?

[bo8482]

Hi
This is what I hope would be a fairly straightforward question.

I have a form with two subforms. The two subforms are bound to queries. The main form is bound to a 'client details' table.

When the form loads, the main form loads up blank (cos user has not selected a client). However the two subforms load up the first user in the query. How do I get them to load up a blank?? (ps i don't want to switch it to data entry mode because I want users to be able to cycle through records too)

I would have thought this would be a common problem but have trawled this site but haven't found anything...or maybe i'm searching for the wrong thing...?
Thanks for any help you can offer
Brian

 

[WIS]

Hi
This is what I hope would be a fairly straightforward question.

I have a form with two subforms. The two subforms are bound to queries. The main form is bound to a 'client details' table.

When the form loads, the main form loads up blank (cos user has not selected a client). However the two subforms load up the first user in the query. How do I get them to load up a blank?? (ps i don't want to switch it to data entry mode because I want users to be able to cycle through records too)

I would have thought this would be a common problem but have trawled this site but haven't found anything...or maybe i'm searching for the wrong thing...?
Thanks for any help you can offer
Brian

Brian

What are the Parent Child link flds between the main form and the 2 subforms.

 

[bo8482]

They are linked by ClientNumber....(which is primary key of table 'client details'). Primary key for two subforms is autonumber.

Does that help?

 

[WIS]

They are linked by ClientNumber....(which is primary key of table 'client details'). Primary key for two subforms is autonumber.

Does that help?

If the 2 subforms are running an autonumber and you try and link to the main form then that's why it won't work. Can you have the ClientNumber in the 2 qyrs running the subforms - I assume ClientNumber is a PK in the Client Details tbl. The Parent Child link will then be the ClientNumber.

 

[bo8482]

Hi
Yes the parent child link is the client number, and clientnumber is in both subforms as well.

Is it possible to get a blank record set on load, and then assign a record set after combo update? Is that possible? What would be the code for doing that (I am rubbish with VBA)?

 

[WIS]

Hi
Yes the parent child link is the client number, and clientnumber is in both subforms as well.

Is it possible to get a blank record set on load, and then assign a record set after combo update? Is that possible? What would be the code for doing that (I am rubbish with VBA)?

I'll need to think about that. Can you post a zip file of the db with some dummy records in it?