problem with form/table

[king07]

Good Morning

Hopefully this makes sense-- i have my db setup for employee development. What i have found is that when a new record is created within my form not all the information from the form gets updated into the table. The problem that this creates is that when my users pull a query for development status the new records are missed because of the table not pulling all updated fields from the form.
Does anyone have any idea how to fix this??

Thanks in advancem

 

[Guus2005]

you probably use a bound form?
are you sure all the fields are bound?

 

[king07]

not sure-- if it is bound what is the best way to fix it?

 

[king07]

Okay-- so the box is not bound-- which is no big deal for me to bind it except for one problem-- this field i have it set to auto sum with the following:

=DateAdd("yyyy",1,[Last Review Date])

is there anyway to still bind it --


The main problem that the users are experiencing is that they add in all information and when they pull a query (dependant on dates) not all records show up and i notices in my table that the fields are left blank due to them being unbound... any suggestions????

 

[Guus2005]

I am not quite sure what your problem is. Could you either post the database or show me the procedure(s) you use to fill the controls?

 

[neileg]

Are you clear on what a bound control is?

Your form should be based on a query. Each control on the form may have one of the fields in the query as its control source. If it does, it's a bound control. Now the value of that control may be determined by entries in other fields, by calculations, lookups, etc. The field in the underlying query, and therefore in the table on which the query is based, will inheirit these values. When you users run a query on the data, these inheirted values will be there. If the field that is bound to the control is a calculated field in the query, then the users will be able to run a query based on this, but only on the query, not the underlying table because the data does not exist in the table.

If the control is not bound to a field, then the data only exists in the form and the users can't query the underlying data in either the query or the table because the data isn't there.