get result from a query

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I want to get the results of a select query (it shows me the highest value
in a field) and add 1 to that value and then write the new value to a field
in another record.

Any ideas?

Karen
 
Hi, Karen.

I think the easiest way to do this is to use the DMax function (see VBA
help). For example, the code to go to a new record and assign the next order
number on opening an Orders form would be:

' OrderNumber is numeric, but not an AutoNumber
DoCmd.GoToRecord , , acNewRec
Me!OrderNumber = DMax("[OrderNumber]", "Orders") + 1

Hope that helps.
Sprinks
 
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

Query Parameter using multiple options 0
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Make Table Query Only Runs After Edit 1
Add autonumber to a large table? 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Ranking Results of a Query 9
a SELECT question? 2
Top 50% Grouped by Month 3

Back
Top