Simple Combo Box

[Jasper Recto]

I have a text field where a user enters a part number. From that part
number, I want a combo box to list all the different revisions it has.

How would I do this?

Thanks,
Jasper

 

[Jeff Boyce]

Jasper

It all starts with the data...

"How" depends on how your data is structured...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jasper Recto]

Sorry,
Let me give a bit more information.

I have a continous form that has a text box to enter in a part number. From
that part number, I have a query that lists me the possible revisions for
that part.

From those 2 bits of information, I have a button that would run a macro the
requeries a query to populate the form.

So basically, I need the text box to run the part revision query and display
in the combo box.

Thanks,
Jasper

 

[Jeff Boyce]

Jasper

Thank you for the clarification of how your forms are working.

"How" to do what you asked STILL depends on how you've organized your data.
In Access, data is stored in tables.

Please describe what data elements you are storing in what tables...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jasper Recto]

Jeff,

I have 7 linked tables to another database. The main query links all those
tables together although the Part number and Part Rev are on the same table.

I hope I'm answered your question correctly! Sorry for the confusion. As
you can tell,I'm fairly new to access.

Thanks!!
Jasper

 

[Jeff Boyce]

Jasper

I'm not doing a good job of asking...

Here's an example of the data in the tables ... these are not yours, so it
would help if you described your data in your tables:

tblPerson
PersonID
FirstName
LastName
DateOfBirth

tblClass
ClassID
ClassTitle
ClassDescription

trelEnrollment
EnrollmentID
PersonID
ClassID
EnrollmentDate

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[CorporateQAinTX]

If you know where the data is and the tables are set the way you want them,
then what you'll need to do next is a LOOKUP function.

You can get some very detailed instructions on using lookups in your Access
Help file. Just search for LOOKUP.

Hope this is more Helpful.

 

[John W. Vinson/MVP]

If you know where the data is and the tables are set the way you want them,
then what you'll need to do next is a LOOKUP function.

You can get some very detailed instructions on using lookups in your Access
Help file. Just search for LOOKUP.

Umm...

Access does not have a function named LOOKUP.

It does have a domain function DLookUp that is *sometimes* useful, but
would almost certainly not be the first choice off the mark in a case
like this!