Editing Data on a form

[Guest]

I have a form base on a Query, and I would like
to edit some data. I have a Query the combines
PO# and Invoices, it sums and balance, etc.
I would like to have the form display two other
fields from the Orders table, which is one of the
two tables of the query, the other is Invoices.
I would like to use the form to display date and
when the time come to close the Order use this
form to record the Order CLosed Date and the Order
Filled Yes value.

Lin

 

[Larry Linson]

You should start by reading Access Help on updateable queries. One vital
thing is that you need the key fields of any table to be updated to be
included in the Query. Even so, depending on the joins in the Query, the
Query may not be updateable. If so, you may need to use VBA code to write
the updated information to one or more of the Tables.

I'm a little confused... you talk about PO#, Invoices, and Orders but
indicate only the Orders and Invoices Tables in the Query. I'd have to
assume that the two Fields you mention by name are from the Orders table (as
referenced earlier) but you didn't say so. You also did not tell us what you
did to try to make your desired result happen, what is actually happening,
nor what question you want answered. So, if what I wrote (guessing at
various unstated items) does not solve your problem, you would improve your
chances of someone being able to help if you'd clarify those issues.

Larry Linson
Microsoft Access MVP

 

[Guest]

Found a way to accomplish what I want by using a form with a subform. But I
have posted another question regarding that and that deals with Tabbing back
to the main form out of the subform. No response as of yet on that one.

Lin