Recent content by ClaraBarton

No, the ID is not the autonumber field used for relationships. The ID is a SECOND field used for other filing, but still required. I figured out a work around. I check for missing field and then throw up a message telling them to pull it into Excel and add an empty column named ID. Works good...

Records have an autonumber that's used for relationships. This is just a file number they use. It's there so I have to deal with it.

No no. The import is contact data that is new people that are added to the main table of customers. They're collected by a third party. No relationships until there are sales and reps. I know the field needed. It's ID but not used until the records are added to the main table.

After checking an imported table, if a column is missing, I need to add it to the temporary table before it can be imported to the main table. The ID (not the autonumber main ID but a second one) is built using a recordset but if the column is missing it breaks. Occasionally a user will omit it...

I think that Public Function fnUpdateZZTable(ByVal tName As String) needs to clear the zztable before appending records.

I have been working long on an export/import form that actually works. I took yours, arnelgp, and ran. I added import capability, file pickers, and prettied it up to match the rest of my forms. The import function is rather specific to my needs but could be easily modified by anyone else. I...

Believe me, arnelgp, I'm indulging. Although yours is a lot prettier, I got hold of Majp's form and started reworking it. I had been working on my own mess for HOURS and DAYS and now am starting over with his. Thank you so much.

OK, guessing that's a personal message. How do I do that? I don't see his address.

uh... PM?

This is like tempting with candy!

Great! how do I do this?

For what it's worth... I went a different route. I created a 2nd continuous subform with a combo that is not connected to the main form. Works great. Thank you all for the ideas.

You hit it. That's exactly what's happening. Thank you for your time.

last record selected. Each combo is a different row (record) but all the little info boxes return the same values as one of the records. Whichever one was just updated.

This is a continuous form. The combo returns a customer id to to tie it to the main form and an item ID for the item. I have different items in each row but all the above information is for the most recently selected (last item) field. why doesn't it stay the same as the record selected?