Text Box

[Dave]

I have created a text in a form. I know I can do this with a query but
as the data comes from a table I don't want to use the query for this
problem. How do I put this a fixed rate of 5% for each new entry. The
text box has a control source from a table.

[pietlinden@hotmail.com]

Re: Text Box


Dave wrote:

I have created a text in a form. I know I can do this with a query but
as the data comes from a table I don't want to use the query for this
problem. How do I put this a fixed rate of 5% for each new entry. The
text box has a control source from a table.

If you want this at table level, set the default there in the field's
default value property. If you want to do it at form level, set it in
the textbox contol's default value property.

[ManningFan]

Re: Text Box

It's a good idea to create a query for every table in your database,
because many times you have to perform operations on fields like this.
In most of my DB's, for every tblSomething there's a corresponding
qrySomething which contains all records from tblSomething plus any
formulas I need based on the data. It saves alot of time in the long
run.

Dave wrote:

I have created a text in a form. I know I can do this with a query but
as the data comes from a table I don't want to use the query for this
problem. How do I put this a fixed rate of 5% for each new entry. The
text box has a control source from a table.