textbox used as report parameter

J

jh

(I am new to access) I have a textbox in a form which is bound to a query's
parameter criteria. I defaulted a value on that textbox. When I click on the
'print' button in the form a report prints which is bound to the query. All
this works fine.

The problem is that the textbox doesn't allow a user to change it's value.
When I click on the textbox and try to type in information nothing happens
(the textbox is enabled).

thanks in advance.
 
D

Duane Hookom

Make sure the Control Source property of the text box is empty. If you want
to set a default value, use the Default Value property.
 
J

jh

Duane,

The Control Source property of the text box is empty and the default value
is set using the Default Value property (it is set to =Now() . I have also
tried it without setting a default value).

The query sql is as follows:
SELECT Main.*
FROM Main
WHERE (((Main.Agreement_Issue_Date)<=[Forms]![frmEnterDate]![txtDate])) OR
((([Forms]![frmEnterDate]![txtDate]) Is Null));

The query runs fine. The problem is that the text box behaves as if it were
locked because it doesn't allow me to enter anything into it.
 
D

Duane Hookom

What are the data properties of the form and the text box?

--
Duane Hookom
MS Access MVP


jh said:
Duane,

The Control Source property of the text box is empty and the default value
is set using the Default Value property (it is set to =Now() . I have also
tried it without setting a default value).

The query sql is as follows:
SELECT Main.*
FROM Main
WHERE (((Main.Agreement_Issue_Date)<=[Forms]![frmEnterDate]![txtDate])) OR
((([Forms]![frmEnterDate]![txtDate]) Is Null));

The query runs fine. The problem is that the text box behaves as if it were
locked because it doesn't allow me to enter anything into it.


Duane Hookom said:
Make sure the Control Source property of the text box is empty. If you want
to set a default value, use the Default Value property.
Click to expand...
Click to expand...
 
J

jh

Thanks Duane,

You have led me to where the problem was. The AllowEdits property of the
form was set to "No". I just set it to "Yes" and now it's allowing me to
enter info.

Best Regards,
jh

Duane Hookom said:
What are the data properties of the form and the text box?

--
Duane Hookom
MS Access MVP


jh said:
Duane,

The Control Source property of the text box is empty and the default value
is set using the Default Value property (it is set to =Now() . I have also
tried it without setting a default value).

The query sql is as follows:
SELECT Main.*
FROM Main
WHERE (((Main.Agreement_Issue_Date)<=[Forms]![frmEnterDate]![txtDate])) OR
((([Forms]![frmEnterDate]![txtDate]) Is Null));

The query runs fine. The problem is that the text box behaves as if it were
locked because it doesn't allow me to enter anything into it.


Duane Hookom said:
Make sure the Control Source property of the text box is empty. If you want
to set a default value, use the Default Value property.

--
Duane Hookom
MS Access MVP
--

(I am new to access) I have a textbox in a form which is bound to a
query's
parameter criteria. I defaulted a value on that textbox. When I click on
the
'print' button in the form a report prints which is bound to the query.
All
this works fine.

The problem is that the textbox doesn't allow a user to change it's value.
When I click on the textbox and try to type in information nothing happens
(the textbox is enabled).

thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Top