Make an updateable query

[Guest]

Hi

Description
I am having problems creating an updateable query to base a form on. I wish
to have a continuous form displaying various envelopes we hold in stock for
any particular customer. Obtained from customer table, stock items table and
stock description table. (This part I can do). To assist in preventing
duplicate updates to stock holding I need to display the last movement
quantity and date. I have a totals query that returns the last movement
details for each stock item.

Problem:
If I add the last movement details as a subform I lose the ability to have
continuouos forms (an almost mandatory requirement as often there is only
minor differences in the envelope description and without a single view of
the customer's envelopes in stock the user may update the wrong one). I added
the totals query to my record source and returned all the data I required
however I can not make the recordset updateable. I suspect this is because it
has a totals query included. The inconsistent updates property doesn't make
any difference.

If any one has any solution or better way of approaching problem this I
would be extremely happy.


Thanks in advance,

Terry

 

[John Vinson]

I suspect this is because it
has a totals query included.

It is.

Use the DMax() function rather than a (SELECT MAX(... subquery. The
function will accomplish the same end, but not prevent updating.

John W. Vinson[MVP]

 

[Guest]

John,

Thanks for that. I should have thought of this myself ....? duh.

Thanks again,

Terry