unbound

  • Thread starter Thread starter mike via AccessMonster.com
  • Start date Start date
M

mike via AccessMonster.com

hi

I had a form link by by a query it works fine. i want to add a text box
"unbound", so i could enter a number any number. I want this number to be
save in the field of my table. can any one help me the code for this ?

lets say my table name is : table1
fieldname is : onhand

thanks
 
Mike

It may be a matter of semantics...

"Unbound" means not connected to a table. If you add an unbound field in
your query, it isn't connected to the table.

Besides, if you want to add a value to a table, that's what Access forms are
for...

Good luck

Jeff Boyce
<Access MVP>
 
I had a form link by by a query it
works fine. i want to add a text box
"unbound", so i could enter a number
any number. I want this number to be
save in the field of my table. can any
one help me the code for this ?

lets say my table name is : table1
fieldname is : onhand
Click to expand...

I can see that you might want to save the number to a Field in a Record in a
Table that is not included in the RecordSource of the Form. If it IS in the
RecordSource, you should bind the Control to that Field, and work to make
the Query updateable (often that only means including the Primary Key of the
Table you want to update, along with other information).

But, if it is a different Table, how do you determine which Record you want
to save it in? A new Record, or a Record that is related somehow (explain
how) to what is displayed on the Form?

Larry Linson
Microsoft Access MVP
 
Back
Top