Not retaining data

[baba78]

Hi,
On the (very basic) database i have created i have a form that users will fill out. At the top section of this there are fields for basic info such as location, company, date, inspector - when the users are filling it out though only some of these fields are retaining the information after it's been closed. I can't see any rhyme or reason for this - if it was an issue of user rights then surely it wouldn't retain any of the info would it??

 

[DCrake]

Is the missing data using bound controls or not?

 

[baba78]

Not quite sure, what does that mean - tell me how I can find out and I'll go and have a look....

 

[DCrake]

If you go into the design of the form and look at the controls that don't seem to be working. Do they have a name in them for the Control Source or is it blank?

If you are unsure post a copy of the data base (Not Access 20007)

 

[baba78]

Just checked and you're right, they're all 'unbound' - any ideas where i go from here?

 

[DCrake]

Is you form bound to an underlying table or query? if so set the control source to map the field in the table/query.

 

[baba78]

They're all combo boxes that i put in, they're the fields that are unbound. They are based on tables which act as the list. How can I set the control source to retain the data?

 

[baba78]

hang on - think i've done it by going into properties!