Hi.
Okay, I've got a combo box , zip, of zipcode, city, state,zipcodeID on form
Clients. It shows the zipcode, but the bound column is 4, the zipcodeID.
I've got input limited to the list and if an input isn't in the list, it
runs the On not in list sub that opens a screen for adding a new zipcode
plus city and state to the zipcode file, via form ZipCityState. When that
window pops up, all the controls are blank. I want the zip code control to
default to what I put in on the first window, the clients window. No way,
no how can I get that to happen. I know it has to do with OpenArgs, but when
I put the me.zipcode variable in the openargs position, it puts a 1 into the
zipcode field on my zipcode window. Not what I'm after.
And, since I'm never satisfied, I also would like the zipcode, once newly
stored into the zipcode file to be the default on the Clients screen's zip
control once it's returned to.
I've tried this same stuff on a control that's just text and it works like a
charm. But I can't get it to work with a combo box.
Suggestions?
TIA
ron