Form is editing tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

DELETE FROM a table WHERE... 1
Edit Records by Form 6
Testing if record in form is available for editing 1
editing a set of records selected from value in a second table 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
cboselection box-can I use it to enter data? 3
Data Entry Form and Auto Number ID 2
Add a "Counter" to a Form 10

Back
Top