making a form for people to fill in

N

nmosk

basic question, i have an inventory table and i want people to fill in a form
to add to my table database. When I use my form I never see what was added
to my table untill I do a search for in this table. i.e. I type in (on the
form) sample name: bla bla and when I go to the table I do not see the bla
bla under the field sample name.
this is very basic in that I just want people to fill in the form and then
have it appear on the table. These 2 would be the only thing in this
database.

plus how do you use the aded 'search for buttons' that i have placed on my
form they do not seem to work.

I am very new at this

thanks
 
G

Golfinray

First, I would make sure that my table is editable, that is there is the
arrow and asterisk at the bottom. If your table is not editable your form
won't be either. If it is editable, try using a command button on the form
(use the wizard to set it up) to save records. It should save the record in
the table. Also make sure that the recordsource of the form is not a query.
If it is, your records will be saved in the query, not the table.
 
L

Linq Adams via AccessMonster.com

Also make sure that the recordsource of the form is not a query.
If it is, your records will be saved in the query, not the table.

Records don't reside in queries and thus are not "saved in queries," they
reside and are saved in tables!

But I suspect that Golfinray is correct in saying that the problem is that
you're looking at the table before the record has been saved.
 
K

Klatuu

Is your table or a query based on your table specified in the Form's Record
Source property?
Are the fields in they table bound to controls on the form? That is, select
the control where you enter bla bala and open the properties dialog box. In
the Control Source property, you should have the name of the field in the
table you want the value to go into.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top