iworkonline
Registered User.
- Local time
- Today, 10:21
- Joined
- May 25, 2010
- Messages
- 44
Here is the problem I am trying to solve, I have not encounter this before. Let me describe the scenario
table1
ID--VALUES
01-games
02-video
03-other
I have combo box that needs to display VALUES from the above data.
and the user should be able to select the values and I am storing the ID in the table. If the user selects 'other' than a text box appears and types the value which is saves in a table..
When the form loads I want the VALUE to be displayed based on the ID that the user has selected.
the current settings of the combo box is
colum count 2
column widths 0;1
row source = select statement
control source = name of the field
right now on the form load it dispalys the ID, and if I select different VALUE I get an error msg:
"you may have entered text in a numeric field or a number taht is larger than teh fieldsize setting permits"
I hope it makes sense. thanks for the help
table1
ID--VALUES
01-games
02-video
03-other
I have combo box that needs to display VALUES from the above data.
and the user should be able to select the values and I am storing the ID in the table. If the user selects 'other' than a text box appears and types the value which is saves in a table..
When the form loads I want the VALUE to be displayed based on the ID that the user has selected.
the current settings of the combo box is
colum count 2
column widths 0;1
row source = select statement
control source = name of the field
right now on the form load it dispalys the ID, and if I select different VALUE I get an error msg:
"you may have entered text in a numeric field or a number taht is larger than teh fieldsize setting permits"
I hope it makes sense. thanks for the help