update queries

i have an update query and i want to update a lookup field. how can i select the data/value instead of typing it? because if i type it the value does not become updated when i change the value in the lookup source.

moreover i encounter problems with the criteria i am trying to set in another field. the records are numbers and i want to select for example a record that is equal to number 5 and the records that are between 100 and 150 and between 312 and 314. could you give me a hint on how to build the criteria?

thank you in advance for your help!

The first paragraph needs more description. Please break down to smaller
pieces.

The 2nd PP:
SELECT *
FROM tablename
WHERE
field = 5 OR
field Between 100 And 150 OR
field Between 312 and 314


--
Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.fmsinc.com/consulting/

"angie" wrote in message
news
i have an update query and i want to update a lookup field. how can i
select the data/value instead of typing it? because if i type it the value
does not become updated when i change the value in the lookup source.

moreover i encounter problems with the criteria i am trying to set in
another field. the records are numbers and i want to select for example a
record that is equal to number 5 and the records that are between 100 and
150 and between 312 and 314. could you give me a hint on how to build the
criteria?

thank you in advance for your help!

in the update query i want to fill in the "update to" in a particular field with a value.

i fill in the value and i get the results i want successfully.

the field, however, is a lookup field (i select with a combo box the value from a query when i open the table)
and it would save me time if i could salect the value in the update query too instead of typing it.

i hope i 've stated the problem more clearly now!