Running multiple query subforms from1 input box

[Locopete99]

Hi Guys,

I'm at the next stage of my database design but I've hit a stumper.

I have 3 subforms that I want to show on a form.

These would be different lists around 1 account.

For instance there would be "pending authorisation by account", "due to expire by account"and "all by account"

I know how to get the query to ask for the account number, but I dont want the user to have to type the same information in 4 times.

is there a way to do this from an Input box that runs when you click the button to open the form?

How would I get this into the query criteria? would I have to make another table and link it, or can you do it directly from a DIM value held on the form?

I don't have any examples yet as I haven't built this part.

It would basically show Agreement number, part number and also have in the account where the criteria would be xxxxx??

I'm a bit stumped. any help or nudge in the right direction would be appreciated.

 

[Minty]

Have an unbound textbox on the parent form. Populate this with your account number, either when opening the form or have it a a combo box possibly displaying the customer name?
Put the unbound textbox as the parent field for all your sub forms in the Parent/Child form design.

You can also simply refer to the same combo / text box on the form, in your queries if they aren't going to be used anywhere else.

 

[Locopete99]

Hi,

Just trying to find the best way to do this.

Ideally i'd like an input box on clicking the open link.

can you use a record set to populate the unbound text box or do I need to have this as a box a user entry box?