Execute query opening a form

[verhp11]

Hello all,
I have a question, I have a form from where I would like to publish data from a parameter query.
I have six textboxes which should be filled with output from the parameter query , for each textbox there the query should be called with a different value as parameter. I've been busy with trial and error but just not get it to work.

Any tips?

Thanks in advance,



Peter

[Bob Fitz]

Try binding the form to the query and the textbox controls to the fields of the query.

[verhp11]

Hi Bob,
Thank you, for one outcome query this works, but how can I pass a parameter to the query to show the outcome in the textbox?

[Welshgasman]

Hi Bob,
Thank you, for one outcome query this works, but how can I pass a parameter to the query to show the outcome in the textbox?

Use TempVars?

[Bob Fitz]

Hi Bob,
Thank you, for one outcome query this works, but how can I pass a parameter to the query to show the outcome in the textbox?

Not sure what you mean by this but I'm guessing that what you want could be done by having a button, perhaps in the header section which runs one line of code:

Me.Requery

[CJ_London]

struggling to understand your description since you should just need to run the query once or perhaps approach from a different direction. Suggest provide some example data, the sql of your parameter query and the outcome required from that example data for the six textboxes on your form

[mike60smart]

Can you upload the database? It makes it much easier when we can see the structure of your tables etc...

[Micron]

I think the request is how to get data typed into form controls into the query fields as parameters. In other words, when the query is run, it looks to the form controls for the parameters. It would help a lot if verhp11 could clarify the request.

[verhp11]

Can you upload the database? It makes it much easier when we can see the structure of your tables etc...

I tried, but got a message that the DB is to big to upload.
I would try to clarify:

1. There is a table within the database which holds records from 6 different locations (location is a field in the record).
2. In the form I have 6 textboxes where I want to show a count of records of each location.
3. When I start the form I want to fire a query for each textbox to fill with the count of records for that specific location.

The question is how to achieve that. I hope that makes is a bit clearer? Sorry for the fuzz

[Bob Fitz]

I tried, but got a message that the DB is to big to upload.

Run Compact and Repair and then Zip the db.
Have you tried using DCount() as the Control Source of your textboxes.

[Welshgasman]

I tried, but got a message that the DB is to big to upload.
I would try to clarify:

1. There is a table within the database which holds records from 6 different locations (location is a field in the record).
2. In the form I have 6 textboxes where I want to show a count of records of each location.
3. When I start the form I want to fire a query for each textbox to fill with the count of records for that specific location.

The question is how to achieve that. I hope that makes is a bit clearer? Sorry for the fuzz

I would just use a Dcount().

[verhp11]

Run Compact and Repair and then Zip the db.
Have you tried using DCount() as the Control Source of your textboxes.

Hi all, I checked Dcount out, and got it to work.
You do have to set focus on the textbox when loading, but it works.

Thank you very much, you made a Access junior happy

[Welshgasman]

Hi all, I checked Dcount out, and got it to work.
You do have to set focus on the textbox when loading, but it works.

Thank you very much, you made a Access junior happy

Not if you set them as expression in the control source?