textbox used as report parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(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.
 
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,

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.
 
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...
 
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...
 
Back
Top