Qry showing AutoNumber as A. B or C.

[Andy]

Hi;

Using a Select Qry to display the ID Autonumber of an open Form.
IDNumber: [Forms]![frmCustomers]![txtCustomerID]
Note: txtCustomerID is an Alias for CustomerID.

When the Qry is run it shows the ID number as A, B or C.
Although it shows as a number on the Frm.

And it will continue to add Alpha letters if the User adds new records.

Even tried adding a control with its source as Name: FedFromID Record
Source=txtCustomerID and changing IDNumber:
[Forms]![frmCustomers]![FedFromID]

Would someone be so kind to point me in the correct direction to correct
this.

Thank You for taking the time to read this post.

Andy

 

[Jason Lepack]

http://www.mvps.org/access/lookupfields.htm

Cheers,
Jason Lepack

 

[Andy]

Jason;

Thank You for the reply.

I read the info at the link.

It tells us what we already know about the results in the lookup.

Is there a work around to get the correct information in the lookup?

Thank You again.

Andy

http://www.mvps.org/access/lookupfields.htm

Cheers,
Jason Lepack

Hi;

Using a Select Qry to display the ID Autonumber of an open Form.
IDNumber: [Forms]![frmCustomers]![txtCustomerID]
Note: txtCustomerID is an Alias for CustomerID.

When the Qry is run it shows the ID number as A, B or C.
Although it shows as a number on the Frm.

And it will continue to add Alpha letters if the User adds new records.

Even tried adding a control with its source as Name: FedFromID Record
Source=txtCustomerID and changing IDNumber:
[Forms]![frmCustomers]![FedFromID]

Would someone be so kind to point me in the correct direction to correct
this.

Thank You for taking the time to read this post.

Andy

 

[Andy]

Hi;

Discovered that with a new record the CustomerID does not show in the
tblCustomers until the record is cycled that is why tried using
[Forms]![frmCustomers]![txtCustomerID] in the query.
It was displaying an Alpha instead of a Numeric.

Through a lot of trial and error and error and error...
Learned about Recordset.Requery.

Added it to the VBA BEFORE running the Qry.

Thank You all, especially Jason, for Your help.

Andy

Jason;

Thank You for the reply.

I read the info at the link.

It tells us what we already know about the results in the lookup.

Is there a work around to get the correct information in the lookup?

Thank You again.

Andy

http://www.mvps.org/access/lookupfields.htm

Cheers,
Jason Lepack

Hi;

Using a Select Qry to display the ID Autonumber of an open Form.
IDNumber: [Forms]![frmCustomers]![txtCustomerID]
Note: txtCustomerID is an Alias for CustomerID.

When the Qry is run it shows the ID number as A, B or C.
Although it shows as a number on the Frm.

And it will continue to add Alpha letters if the User adds new records.

Even tried adding a control with its source as Name: FedFromID Record
Source=txtCustomerID and changing IDNumber:
[Forms]![frmCustomers]![FedFromID]

Would someone be so kind to point me in the correct direction to correct
this.

Thank You for taking the time to read this post.

Andy

 

[John W. Vinson]

Is there a work around to get the correct information in the lookup?

Yes.

Use a Form with a combo box rather than trying to use a Lookup Field in a
table.

John W. Vinson [MVP]