textbox value to be inserted in the combobox

F

FA

Hi, I have a form called frmSystem and a form called frmTesterNames. On
the frmSystem i have a combo box for called cboTesterNames and next to
the combo box is a command button that opens frmTesterNames that shows
list of availablel Testers. On frmTesterNames i have a text box that
shows the tester names and next to each text box is command button
Select. if the user click on select i want the value of the text box to
be populated in frmSystem cboTesterNames. cboTesterNames is based on
the same table as the textbox on frmTesterNames. frmSystem will remain
open during this operation so i dont know how to insert the a value
from on text box on a form to a combo box on another form. Remember the
textbox and the combo box are based on field.

i will really appreciated your response.

thanks
moe
 
J

jahoobob via AccessMonster.com

You seem to be going around your elbow to get to your nose from your finger.
A combobox based on TestersNames will do in a strasight-forward way what you
are attempting to do in a round-about way.
 
F

FA

I do not think you have completely understood my issue. let me try to
more clearify.
Form1 = frmSystem ==> Table--> SYS_INFO Controls--> cboTesterName
,CommandButton--> Availability
cboTesterName-- ControlSource = Tester_Nme_ID

i keep it as cboTesterName as a combo box because a user can either
select a tester from the choices in the combo box or look for the
availablily. when the ues click on Availibilty, a popup form will apear
with showing the available testers. The tester names will be the same
as the choices in the combobox except the fact that those tester names
will not appear who are busy during specific dates.

Form2 = frmTesterName ==> DataControl == qryTesterAvailibity
Controls--> txtTesterName, txtTesterNmeID, Command--> Select

When the user click the select command from the popup form i want that
tester name to appear in the combo box of frmSystem.

I dont know if i explain my issue clearly but your help and responses
would really help me achieve this.

Thanks alot
Moe
 
J

jahoobob via AccessMonster.com

You can show the availablity of the testers in the combobox and the user can
select one who is available when needed. Add the columns (in the combobox)
from the table that you would have used in your subform to determine
availbility.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top