Subforms (Access 2000)

Topic

New Reply

Hello,

I have a user who would like to review the net returns of 4 mutual funds at one time. The user types in the individual fund id to run the queries. So far, I have a main form and 4 subforms that are able to accomplish this. However, now the user would like to delete one of the funds and add another without changing the other 3. (Each subform is attached to its own query.) How do I keep the main form intact without starting all over?

Is this done with a macro?

Thanks.

Reply | Quote

Replies

Would I be correct in assuming that you have 4 combo boxes on your main form and you select the ID in each box for each of the subforms and that the combo box selection supplied the criteria for the query each subform is based on? Or have you designed a different solution?

Reply | Quote

Rupert,

In the critieria of the underlying query, it asks for a fund id. The user then types it in and the query runs.

Thanks.

Reply | Quote

Four times?

Reply | Quote

Yes.

Reply | Quote

>>It doesn

Reply | Quote

So an idiot would eventually turn in to an expert. Yes! I like the sound of that. Some experts I know were obviously idiots in the past and I

Reply | Quote

Add a button to your subforms to requery the recordsource. This should again ask you for a the fund ID.

Reply | Quote

Mark,

This sounds very easy, but I am unsure what steps to take to do this. When I make command buttons, I use the wizard. Do I run a macro to requery? If so, when I have the action that says requery, what do I put in the control name.

Thanks for your help.

Reply | Quote

What

Reply | Quote

They are in continuous view.

Reply | Quote

As to your question about the command button and running the query with a macro, I think you would be better off using the

Reply | Quote