Creating a data entry form from a query

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

Guest

So I am not sure that this form is even possible but...
I would like to make a form for my users where they would be able to look up
data on a sales order and either just look it up or add/change data through
the form. The problem is to get all of the values I need in the form I have
to run a query with two big tables and one small currently empty one that
will store the entered data to be found by the query when the sales number is
entered. Every thing will be referenced by the sales order in form, meaning I
would like to enter the number and have the record be found quick and easy.
However, I tried making a form from a query and it will not allow me to
change any of the data, but only scroll through the records with the buttons
at the bottom.

Is this impossible?
 
As you've discovered, not all queries result in a recordset that is
updatable. Short of restructuring your data, you could try changing the
join property of your query, and/or using a form-subform approach. The main
form would have an updateable recordsource representing the "One" side of
the relationship, and the linked subform would have data from the "Many"
side.
-Ed
 
Back
Top