list box to choose one specific record

M

MRL

Trying to use a list box in a pop up form to select one specific record to
print from a query that may have more than one result. When 2 numbers are
entered in the main form to query the database to print a specific
instruction booklet there is a possibility that the query can return more
than one record. When this happens the second form comes up with a list box
bound to the "Machine Decription" field of the query. I want the user to
select the correct machine and click the "OK" button, closing the form &
printing that specific user asked for instruction booklet for that machine.
Trying to get it to display the specifc record first but its telling me the
control can't be edited because it is "Bound" to an expression.
Thanks
 
R

Rick Brandt

MRL said:
Trying to use a list box in a pop up form to select one specific
record to print from a query that may have more than one result.
When 2 numbers are entered in the main form to query the database to
print a specific instruction booklet there is a possibility that the
query can return more than one record. When this happens the second
form comes up with a list box bound to the "Machine Decription" field
of the query. I want the user to select the correct machine and
click the "OK" button, closing the form & printing that specific user
asked for instruction booklet for that machine. Trying to get it to
display the specifc record first but its telling me the control can't
be edited because it is "Bound" to an expression.
Thanks
Click to expand...

So what is the ListBox bound to? (What is it's ControlSource?) Sounds like
it doesn't need to have one at all.
 
M

MRL

It is connected to the [Machine Description] field of the query generated by
the first form's input (an 8 digit part # & a 4 digit operation #). I have
one part operation in the DB with a 2 machine option that I can view the
machine names in the list box but I can't edit it cuz it bound to the above.
Do I unbound it, but then I may lose the machine list generated by the query.
Reading more on unbound list, between that & beating my head against the
wall, maybe it will sink in.
 
Top