Records in forms

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

Guest

Can someone assist me with this Please!! I have created a database and have
4 different forms in it, each time I click on the last text box I have the
command going to the each form after I enter data into the last text box and
for some reason the only form that changes the records is the first one. I
need the forms to go to the next record.

Thanks
 
Are all 4 forms based on the same table? If they are then you could, in code,
before you open the next form, go to the next record and set the condition
for opening the next form to the new, current record of the current form.
Don't forget to close the first form AFTER opening the second, etc.
 
I created 4 different tables as I was told that access does not like large
tables, as it doesn't work correctly. I have alot of different textboxes,
combo and check boxes in my database tables. Is there an easier way of doing
this.

Thanks
 
I believe that you should design your tables in a way that makes sense, e.g.
put all the personal information about employees in one table but put job and
department information in another because more than one employee can have the
same job and work in the same department. If ten emplyees work the same job
you have stored personal data about them in 10 records but stored job data in
only one record.
How many fields total are in the four tables. If you are duplicating data
(Key fields, such as ID's not included) then you should combine the tables.
You probably combine them anyhow through queries.
Also, don't put comboboxes in your tables, put them in the data entry forms.
As far as large tables go, I think that the table limitation is 255 fields.
I created 4 different tables as I was told that access does not like large
tables, as it doesn't work correctly. I have alot of different textboxes,
combo and check boxes in my database tables. Is there an easier way of doing
this.

Thanks
Are all 4 forms based on the same table? If they are then you could, in code,
before you open the next form, go to the next record and set the condition
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Back
Top