Open form at first Alpha not first record number key

  • Thread starter Thread starter Billp
  • Start date Start date
B

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
 
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
Click to expand...

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.
 
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
 
Check for default.

Billp said:
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
Click to expand...
 
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
 
Back
Top