Lost dataentry fields for next record

[Guest]

after I have finished a record and use the astrisk at the bottom to go to the
next NEW record, two of my fields are missing, I can fill out that
information in the Table where that information is saved, then I'll se it in
the new record, but usually those fields are on the form. How can i get them
back?

 

[John Vinson]

after I have finished a record and use the astrisk at the bottom to go to the
next NEW record, two of my fields are missing, I can fill out that
information in the Table where that information is saved, then I'll se it in
the new record, but usually those fields are on the form. How can i get them
back?

Presumably by having textboxes on the form bound to those fields.

Where are you "finishing" a record? On a Form (ok)? in a Table?

When are they missing, and when are they present?

What is the Recordsource of your form (if it's a form)?

John W. Vinson[MVP]

 

[Guest]

Hi John, thanks for addressing this issue. I am finding it very hard to
explain the problem, would it be possible that i send you a copy of my db so
you can see what I mean?

 

[John Vinson]

Hi John, thanks for addressing this issue. I am finding it very hard to
explain the problem, would it be possible that i send you a copy of my db so
you can see what I mean?

I'm sorry, that's generally beyond the scope of unpaid volunteer
services.

Please answer the questions I asked:


Where are you "finishing" a record? On a Form (ok)? in a Table? What
exact steps do you take when you open the database and try to update
the information?

When are they missing, and when are they present? Can you sometimes
see this data and sometimes can't, or what specifically are you not
seeing that you want to see?

What is the Recordsource of your form (if it's a form)? If it's a
Form, open it in Design view; view its Properties; and tell me what's
in the Recordsource property, first one on the Data tab. If it's a
QUERY or a text string starting with SELECT..., click the ... icon by
it; select View... SQL; and copy and paste that SQL text to a message
here.

John W. Vinson[MVP]

 

[Guest]

It's not a query or text string, it points to the correct table.

 

[John Vinson]

It's not a query or text string, it points to the correct table.

I'll be glad to help... if you'll answer the questions as requested.
Sorry I can't use telepathy.

John W. Vinson[MVP]

 

[Guest]

My apoligies, here are the answers to your questions.
1. I am finishing the record in my form.
2. I can update all the fields as usual, except the ones that are no longer
there, I can even go to the next new record, but those fields will be missing
in the new record too.
3. If I manually add the data to the source table, then go back to record in
the form, the information will now show.
4. The record source is a table “deviation info†there is no icon next to it

 

[John Vinson]

My apoligies, here are the answers to your questions.
1. I am finishing the record in my form.
2. I can update all the fields as usual, except the ones that are no longer
there, I can even go to the next new record, but those fields will be missing
in the new record too.
3. If I manually add the data to the source table, then go back to record in
the form, the information will now show.
4. The record source is a table “deviation info” there is no icon next to it

Ok...

You can see the Controls (textboxes? combo boxes? some other type of
control?) on the Form? Are the controls themselves gone, or just
blank?

What is the Control Source of each such control?

What is the Visible property of each control?

What is the Enabled property of each control?

Have you use Tools... Database Utilities... Compact and Repair
Database (just in case there's some form corruption)?

Do you have any VBA code associated with the Form? (Click the Code
icon in the toolbar in form design view and copy and paste the code to
a reply here if so).

John W. Vinson[MVP]