table population via form & query

  • Thread starter Thread starter cporter
  • Start date Start date
C

cporter

I have a form that I use to populate a table. It works fine after the
first entry has been made but not for the first entry. I'm using a
formula, =DMax("PROCNO","qryPMByMachID")+1, to fill in the procedure
number. If there is no current procedure this code doesn't work. Is
there a way to use this when there is a null value or is there a better
way to do this?
 
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

Append Query Issue 0
Calculated age field not populating after 1/1/09 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Pop up form is not populating query results 0
Populate Dropdown combo from multiple tables 0
"Data Has Been Changed" error with MSSQL 2005 backend using left j 1
Count Records in multiple tables 3
Check box and make table query 1

Back
Top