Record selecting

P

PBrown

Is there away to have a form use a combo box for say [Part
Number] that when the part number is selected, that part
number's detail (i.e. cost, unit measurement, etc) will
appear. Right now I am using a combo box with :
SELECT DISTINCTROW[Service Parts & Volume].[part number]
FROM [Service Parts & Volume];
as the row source, but it is only changing the part number
displayed and not showing the appropriate detail.
Currently the form is reading from Table: Service Parts $
Volume
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Auto fill fields in sub form 1
Form Logic 1
Problem: Combo boxes self-populating 11
Display related field based on combo box 1
option group & subform 5
Assigning a value to a field based on other fields value 8
Assigning specific record data to fields on a form Access 2003 0

Top