Nice simple textbox question

  • Thread starter Thread starter Rob Brookbanks
  • Start date Start date
R

Rob Brookbanks

Help,

I have a form which is bound to a table. The table is a temporary one that I
dump data into while I am in data entry mode. Once the user has finished
data entry the temp table is appended to the main table and then emptied.

All works well, but I want to put a text box on the main form and
temporarily store a 6 digit number in it. This textbox is then the control
for a QBF query that grabs data via ODBC. Once my data entry is finished I
don't care what was in the text box.

The only problem is that if I have an unbound textbox, I can't type anything
in it. What am I missing?

Eventually the textbox will be populated by a barcode scanner and then I can
fill in my form with a query such as
=like[forms].[thisform].[theannoyingtextboxthatdoesntcurrentlywork] Which
grabs data from another database and stores it in this one. (I need to store
the data in my database because the company abuses part numbers and a part
number could bring up whatever text happens to be in there. Nearly every
part is called HW-999....... Don't even go there!) I need to grab the text
from the moment in time when I perform the input.

I have always had trouble with unbound text boxes, I must have missed
something somewhere.

TIA
Rob
 
Have you checked that the enabled property is 'Yes' and the
locked property is 'No'

Hope That Helps

Gerald Stanley MCSD
 
I checked those and they were OK

In the end, I deleted and recreated it in exactly the same way and guess
what??? It worked. I must have got some duff code in there somewhere that I
couldn't see.

Thanks for the reply.


Gerald Stanley said:
Have you checked that the enabled property is 'Yes' and the
locked property is 'No'

Hope That Helps

Gerald Stanley MCSD
-----Original Message-----
Help,

I have a form which is bound to a table. The table is a temporary one that I
dump data into while I am in data entry mode. Once the user has finished
data entry the temp table is appended to the main table and then emptied.

All works well, but I want to put a text box on the main form and
temporarily store a 6 digit number in it. This textbox is then the control
for a QBF query that grabs data via ODBC. Once my data entry is finished I
don't care what was in the text box.

The only problem is that if I have an unbound textbox, I can't type anything
in it. What am I missing?

Eventually the textbox will be populated by a barcode scanner and then I can
fill in my form with a query such as
=like[forms].[thisform].[theannoyingtextboxthatdoesntcurrentlywork] Which
grabs data from another database and stores it in this one. (I need to store
the data in my database because the company abuses part numbers and a part
number could bring up whatever text happens to be in there. Nearly every
part is called HW-999....... Don't even go there!) I need to grab the text
from the moment in time when I perform the input.

I have always had trouble with unbound text boxes, I must have missed
something somewhere.

TIA
Rob



.
Click to expand...
Click to expand...
 
Back
Top