How to update table that is recordsource for combo box that is updating that table

[bigalpha]

I have a combo box (cboManifestNumber) that is based on the following table:

tblManifestData
ManifestDataIDPK (autonumber PK)
ManifestNumber
RemovedDate
ManifestComments
TsdfIDFK (FK frm tblTSDF)

This table is related to:

tblTSDF
TsdfIDPK (autonumber PK)

I need to be able to update tblManifestData with a new manifest number and manifest comments, along with assigning it a TSDF.

I'm not sure how to be able to enter a new manifest number and the associated data without having it create two lines in tblManifestData. I thought that I could enter a new manifest number, then requery the table and form so it shows the complete list of manifest numbers (including the recently entered one) while staying on the newest entry.

I tried everything I could think of, and tried to implement solutions I found through Google searching. I've literally been trying to figure this out all day. Any help is extremely appreciated!

 

[John Big Booty]

The sample here demonstrates one method of managing combo box items.

 

[bigalpha]

The sample here demonstrates one method of managing combo box items.

Thanks, I'll download this and take a look and see if I can get it to work for me. If not, I'll be back to ask some questions.