Query results to multiple textbox

[Danielt949]

Good evening.

Attached is a sample of what i am creating, This is not the whole project, but enough to have an understanding of what i am needing to achieve.

Open up Form1, Select Asset Type and watch the results change in Compliance type combo box.

If you open form design you will see that there are some hidden textbox.
Opening the code you will see that these textbox are hidden from form startup.
I have got code there so that when the textbox value is > 0 the textbox with then become visible.

What i am trying to achieve is that when the asset type is selected it then sends the query results to each textbox, with only 1 result per textbox. I will be deleting the Compliance Type combo box, this was purely put in place to demonstrate the answers given by the query.



The purpose for this is to allow a bigger form to be built around these textbox.

cheers


Database1.zip

[Bob Fitz]

This is not the whole project, but enough to have an understanding of what i am needing to achieve.

Sorry, but for me it does not.
Can you tell us in plain English about the db and what its purpose is.
I suspect that the structure of your tables are incorrect.
For example: In the table called "Table_NewAsset" you have ten fields with similar names: Compliance1-Compliance10. This is very common in a db that has not been "Normalized".

[mike60smart]

It would help if you can explain in detail what your actual process is.

All of the Controls on the Form are Unbound and it is normal to have your Form Bound to a specific Table.

Whoops Beaten to it

[Bob Fitz]

Whoops Beaten to it

I must have started typing MUCH earlier than yourself then

[Micron]

You are doing things the hard way all along and according to the db you posted, are not following advice given in your other threads to normalize your tables.
Regardless, here's what I glean from your latest attachment but only for the problem posted here.
- your form has no recordsource thus it is pointless to requery or refresh it.
- you will have to write code to get anything into your textboxes before you can determine if AssetTypeID > 0 or not.
- if >0 applies to compliance then the empty control is Null. Checking if >0 will return null, not a number.
- labels that are attached to controls get the same visibility as their control, so no need to code for label visibility in your case

Unless you have a good reason for using an unbound form you are just making a lot of work and maintenance for yourself.

EDIT - Forgot to ask which of the 4 records would you pick from your query for the textbox values?
I assumed you left the labels attached but they are not. Attaching them would eliminate label code lines.