Choose From Combo box

[Charles L. Phillips]

Hello,
I am using MS-Access 2003.
This db is for the inventory and upgrade of ALL the current desktops in the
company.
I have a form that contains the following fields:

Current System

1. DellServiceTagNumber (Caption: Dell Service Tag #: Combo Box)

Refresh System (RS)

2. RSDellServiceTagNumber (Caption: Dell Service Tag #: Combo Box)

I am upgrading each User's computer.
I place a service tag number in 1, and get the same service tag number in 2.
This implies, the User did not get a NEW computer.
If the User gets a NEW computer, then there is a NEW service tag number to
be assigned to 2.
I know how to use the "Control Source" of 2 to give the computer the same
service tag number of 1, but I want able to choose, then if necessary, enter
a NEW service tag number for 2 I hope I have been clear.
Can/will someone point me to some examples or samples of my request???


Thank you,

Charles L. Phillips

 

[Guest]

If you are using the control source of #2 to get the value of #1, you will
not be able to update the field in your table that holds the tag number for
#2.
Use the control source to bind the control to the field so it will update.
Use the After Update event of #1 to populate #2.

Me.#2 = Me.#1

 

[Charles Phillips]

Hello,
Sorry for the late response, but "Thank You".
I'll try this weekend...


Charles L. Phillips