Table Information not matching in Form Design

  • Thread starter Thread starter mePenny
  • Start date Start date
M

mePenny

I've created a table with information from an excel file I imported. I've
designed a form to enter information if needed. When i was looking through
the information in the form i designed, the information was scrambled. I
looked at the table and the information is correct.

What causes this to happen?

mePenny
 
the information was scrambled.
Just what do you mean?
Are the records in a different order - That is natural as Access stores
records like bricks in a barrel.
Do you mean field1 data displayed as field2 data? Or do you mean field1
data displayed for wrong record?
Are you using a query to retrive data from table for the form?
 
Field1 data is displayed in the wrong record.

The database is for vehicles:
license plate, vin, yada, yada..
I was looking at trailer 474CK and it was showing information from a car.
 
Post the SQL of your query feeding the form by opening in design view,
clicking on VIEW - SQL View, highlighting all, copy, and paste in a post.

If you are not using a query (you really should) open the form in design
view, right click, scroll down to select properties. Copy the Record Source
and paste in a post.
 
When I right click on form in design view I get a box with different tabs.
Record Source is not under any of the tabs.
 
You have to make sure you do not click on any object. When you open the form
in design view scroll to the right to an area that is not showing dotted grid
and click the open space. Then right click.
 
Back
Top