Mimic a label bound to ID field on form

[BRZ-Ryan]

I am using a combobox populated with ID's (PK) from the bound table on my form. When you click an item in the list, it will navigate to that record ID. When I create a new record, I'd like it to display (new) on new record and populate the ID when the record is created (id created). Anyone have any ideas?

[June7]

Not understanding what you described.

The combobox is UNBOUND and used to enter filter criteria to find existing record?

When you create new record, doesn't the ID automatically generate?

[BRZ-Ryan]

Yes.

Yes, but how do I make it appear in my unbound combobox? The combo is populated with primary keys (auto number).

Imagine you had a label bound to the id field. When a new record is created it s set to (new) and once a piece of data is entered it gets updated to the id for that record.

I'm trying to make easy record navigation where users can select a record by id in a combobox. The selection part is done, I just want it to function like what I had in this location prior, which was a label bound to id.

[ItsMe]

I am not sure I understand your post either but...

Create a label

In the form's current event

If me.newrecord = true then

me.labelname.visible = true
else
me.labelname.visible = false
end if

[BRZ-Ryan]

Not even close, did you read my posts?

[June7]

I wouldn't bother having ID for new record show in the unbound combobox. If the combobox LimitToList property is yes, requires code to save the record, requery the combobox, populate combobox.

Have a textbox bound to the ID field (Locked Yes, TabStop No).

You are using this autonumber ID for a value that has meaning to the users?

[ItsMe]

I did. Did you try my suggestion?

[BRZ-Ryan]

Yes June, the autonumber is the event number for my events db. I'd like it to show when working with new record (new) and when the record has been created (id#). Or just some way of showing the user that a new record was created (no value entered yet so there's technically not a record) and when a value has been selected creating the record

[June7]

Bound textbox should accomplish that.

[BRZ-Ryan]

But I want a combobox.. No room for both on my form.. Is it possible?

[June7]

No room for both!? It's possible - just takes some code. The real trick is timing and figuring out what event.