Need Some Help

[JoshuaNerenberg]

I am developing a data base for my company's vendor and customer claims. I have a form which will open the customer claim report. The form is designed to have a drop down list of all the claim numbers. The user would select the claim number and click the command button to open that claim number. The problem I am having is the claim numbers are an autonumber field. THe form won't let me do anything with the number list.

What is the best way to fix this?

Thanks

 

[Fornatian]

Autonumbers are Autonumbers - hence the dichotomy. They are a 'bookmark' for the record and nothing more.

If you want sequential numbering, which an autonumber field will not tolerate then you need to not use an autonumber and do some research into VBA and DMax().

There is no quick fix unfortunately.
Try doing a search on sequential numbering in thsi forum as it has been covered a few times previously.

Ian

 

[JoshuaNerenberg]

The user would enter the claim infomation in another form. This is simply a form used to open the report, not edit any information.

I am not sure if we are on the same page.

 

[David R]

It sounds like you're looking for a combo box which will open a specific (existing) record. Open the combo box wizard and select the third option, "Find a record based on the value I select."

There have been a gazillion topics on this, but post back if you need further assistance after taking that step.

David R