Form is editing tables

C

ChrisA

How do I make it such that my form will not edit the information on my tables
and queries? I want to be able to type a number on my form and have it bring
up the record in the table that it is referenced to. When I currently type
in the number, it will actually change the value of that record to the value
I type in.

THanks for the help.

Chris
 
K

KARL DEWEY

On your form use a ComboBox or ListBox to select from.

In the query for the for use criteria --
[Forms]![YourForm]![YourComboBox]
OR
[Forms]![YourForm]![YourListBox]

Use a macro or event in your ComboBox or ListBox to open the query.
 
Top