Opening to the next record

[Enrico]

I have a form that takes data from a table which has preassigned policy numbers that I entered. For each policy number there is data that goes with it (ie Name, address, etc). The user fills out this data and closes the database. Is there any way to go to the next policy number that has no data associated with it when the database is opened up again? Any help would be greatly appreciated. Thanks in advance

Enrico

 

[Dreamboat]

Enrico, in the property of the form itself, select data entry = yes. That way, it should always open up at a new form. However, it will not allow you to EDIT existing records. I prefer to have one form for "maintenance" and one form for "new records."

However, if you want to do both, you need to do an on-open built-in macro that goes to a new record.

[This message has been edited by Dreamboat (edited 07-16-2000).]

 

[Carol]

You could create a command button on your form called New Record that when clicked would take you to a new blank form ready for input. As for the prenumbering, if you are using an autonumber field in your underlying table, then the next sequential number would be shown. If you are using a predefined numbering system, then set up a macro to set the number of the new record using "DMax".

Good luck.

 

[Enrico]

I tried using the dmin function in access, but I seem to get the error messages that says compile error due to the macro or expression. I made a command button that has the expression below for event. I want to go to the record that has the INSURED field blank, with no entries.

The code I am using is

Macro1 = DMin("[INSURED]", "PAPolicyBind", "[LINE OF BUSINESS] = 'Mass'")

where

Macro1 = macro that goes to record on a specified form. (GoTo on record space)
INSURED = the field I am searching
PAPolicyBind = the table I am searching
LINE OF BUSINESS = a field I am using to have the search return a NULL value.

Any idea what I am missing here?

Thanks

Enrico