Saving new data in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a database with many forms/queries, and reports...

The issue I am having is on the Forms. I have list/combo boxes for certain
data in the forms. For example, facility, start/end time, etc... This is to
allow the person to choose from a list instead of having to enter the data
each time. The issue is that the form is not saving data from these choices
UNLESS you actually choose a different entry other than the default. In
addition, on the Facility choice (which is a combo box with three fileds -
cost, facility, complex) even choosing a new facility other than the default,
it saves it on the report but not on the "edit" version of the form.

I have played with all the properties, etc... and am lost. Also, if any
knowson the facility combo box, I would like to be able to display in a
Report, just the Complex and Facility and not the cost.

Thanks.
 
Hello,

I have a database with many forms/queries, and reports...

The issue I am having is on the Forms. I have list/combo boxes for certain
data in the forms. For example, facility, start/end time, etc... This is to
allow the person to choose from a list instead of having to enter the data
each time. The issue is that the form is not saving data from these choices
UNLESS you actually choose a different entry other than the default. In
addition, on the Facility choice (which is a combo box with three fileds -
cost, facility, complex) even choosing a new facility other than the default,
it saves it on the report but not on the "edit" version of the form.

I have played with all the properties, etc... and am lost. Also, if any
knowson the facility combo box, I would like to be able to display in a
Report, just the Complex and Facility and not the cost.

Thanks.
Click to expand...

You must "dirty" - manually select or enter - at least one field on the Form
before a new record (with its default values) will be created. Just opening a
form and moving to a new record will not automagically create and write a
record to the table - you do need to do *SOMETHING*.

I have *no* idea what you mean by "saves it on the report but not the edit
version of the form". Data is not stored in reports, nor is it stored in forms
- it's stored in Tables. What is the Recordsource for this form? and what is
this "report"?

John W. Vinson [MVP]
 
Back
Top