Open form at first Alpha not first record number key

[Billp]

Hi,

Say we have a combo box called cboCustomerID linked to a table called
tblCustomer.
CustomerID is always a six letter identifier
The first record (primary key 1) is AABBLA and there are 1149 records.
The query behind the combo box filters the CustomerID ascending starting at
AABBLA ending at WWWABA.

We add another customer record number 1150, it is AAAAAA

On loading of the form I have

cboCustomerID = CustomerID

which sets the form at AABBLA and not AAAAAA which is what I would like.

Any ideas?

Very appreciative of help and assisatnce.

Best regards

 

[KARL DEWEY]

If it is ascending on CustomerID it will still be ascending.

 

[John W. Vinson]

Hi,

Say we have a combo box called cboCustomerID linked to a table called
tblCustomer.
CustomerID is always a six letter identifier
The first record (primary key 1) is AABBLA and there are 1149 records.
The query behind the combo box filters the CustomerID ascending starting at
AABBLA ending at WWWABA.

We add another customer record number 1150, it is AAAAAA

On loading of the form I have

cboCustomerID = CustomerID

which sets the form at AABBLA and not AAAAAA which is what I would like.

Any ideas?

Very appreciative of help and assisatnce.

Best regards

Instead of basing the combo box on the Table, base it on a query sorting by
the customer ID.

It's evident that you don't currently have a sort specified; in that case
Access will present the records in whatever order it finds convenient.

 

[Billp]

Thanks,

Thought it would work however it doesn't appear to be so.
The query when run on its own does alpha ascending.
When implemented in the form it still opens at the first record key not the
first alpha.
So AAAAAA does appear but hidden above the record AABBLA
The form opens at AABBLA.
Oh well - darn.
The combo is unbound - modelled on the northwind example.
Regards

 

[KARL DEWEY]

Check for default.

Thanks,

Thought it would work however it doesn't appear to be so.
The query when run on its own does alpha ascending.
When implemented in the form it still opens at the first record key not the
first alpha.
So AAAAAA does appear but hidden above the record AABBLA
The form opens at AABBLA.
Oh well - darn.
The combo is unbound - modelled on the northwind example.
Regards

 

[Billp]

Thanks,

Yes the default.
In fact by making the form based on the query and sorting the CustometID via
ascending, and also basing the combo on the query it worked.

Thanks for the perseverance and direction
Kind Regards
Bill