Inputting data in a form based on a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello again all,

I want to have a lookup field in a form which has 7 different fields. I
tried using the Query as the Lookup, but seem to be having trouble getting it
to fill in the fields. I wouldn't even mind just making one large field for
all 3 of the results. Ideally, when a person enters the criteria for the
query, the result will fill in 3 of the 7 fields.

Is this possible??

Thanks in advance
 
There might be something wrong with your table structure if you want to
select a value from a combo box and have other columns in the combo populate
other fields in your form's record source. For instance, if your combo box
selected the employee ID and you wanted to also store the First and Last
Names in your form's record source. This would be storing unnecessary
values.

I hope I am wrong and you will correct me about your situation.
 
Hi Duane, thanks for the response.

This database is fairly large, and I have it connecting to some back ends as
well. It is pretty diverse, with a wide range of data being stored, logs,
contact databases, etc. I know I probably do need to realign some stuff but
I don't think it is that bad off. I am kind of pulling from different DB's
and pulling into one as well.

I hope I answered your question a little. I am new to Access like I said.

Thanks again
 
Could you explain better what you expect to happen? Apparently you have a
combo box. Please provide the SQL view of the Row Source and then what you
would want to happen with values from the combo box columns.
 
Back
Top