Advanced ComboBox

Thank you very much, it works great. I almost had it, but messed up a couple
of line until your post. I think I need to learn VB, it looks much cleaner
and I could understand it better then the macro.

Again thanks, you are great!!!

MiHutch

Gina Whipp wrote:
MiHutch,

Okay then I need the name of the forms. ANother thought, you might get a
"Can't save record..." message because of write conflict. You will need to
add a Save command to the form that gets edited on to the Unload.

Here is an example (watch out for word wrap)... DoCmd.OpenForm
"NameOfFormYouWantToOpen", , , "[PKOnTheFormYouAreOpening]=" &
Me![ComboBoxOnFormYouAreOpeningFrom]

However, if this is a seperate function then you might want to attach the
above to a command button.

The forms that I want it to open are separate, but the table that the data
is
[quoted text clipped - 14 lines]
Keep going till all done
End Select

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1

MiHutch,

You are MOST welcome.... and I am glad we have got you past that initial
*fear* of VBA! There are LOTS of examples out there. Here are a few to get
you started...

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

http://allenbrowne.com/tips.html

http://www.rogersaccesslibrary.com/OtherLibraries.asp

http://www.accessmvp.com/

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"MiHutch via AccessMonster.com" u53459@uwe wrote in message
news:997cc7cacc430@uwe...
Thank you very much, it works great. I almost had it, but messed up a
couple
of line until your post. I think I need to learn VB, it looks much cleaner
and I could understand it better then the macro.

Again thanks, you are great!!!

MiHutch

Gina Whipp wrote:
MiHutch,

Okay then I need the name of the forms. ANother thought, you might get a
"Can't save record..." message because of write conflict. You will need
to
add a Save command to the form that gets edited on to the Unload.

Here is an example (watch out for word wrap)... DoCmd.OpenForm
"NameOfFormYouWantToOpen", , , "[PKOnTheFormYouAreOpening]=" &
Me![ComboBoxOnFormYouAreOpeningFrom]

However, if this is a seperate function then you might want to attach the
above to a command button.

The forms that I want it to open are separate, but the table that the
data
is
[quoted text clipped - 14 lines]
Keep going till all done
End Select

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1