Records do not change

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

Guest

Does anyone know how to get the records to change after selecting enter? I
have a few forms and the only one that chnages is the first form. I need all
the records to change so I can add new data into it.


Thanks
 
Your question is not clear. You have a few forms and you want them all to
change after selecting enter? You need all the RECORDS to change so you can
add new data into it?

That does not make sense. Please explain exactly what you are doing.

You should have "A form" opened where you enter data for "a record". After
you move to the next record, select "save", or move to a new record, the one
you just modified will be saved. If you then pull it up again, your changes
should be saved.

More details please.
 
Ok, this is what I have..I have 4 different forms and with command buttons at
the end of each form except the last form. On the last form in my last text
box I have it going to the first form and this one does go to the next record
but after I have finished entering data into the first form it does
automatically to the 2nd form but not the next record, it stays on the first
record. Kind of confussion I know but I couldn't find an easier way to do
this seeing as I'll have a long table if I didn't break up the data.

Thanks
 
Why do you have four forms to enter one record? Why not simply use a tab
control to set up four tabs on one form? Breaking up the data on a table
and a form are two totally different things. You do not have to build one
form for every one table. And, if all the data is truly related in a
one-to-one way, then one single table is probably the way to go. What type
of data are you storing that you would end up with one huge table? I bet
you have a flaw with the structure.

I'm sure someone could give you a quick answer as to how to code this, but
it sounds very very odd. I've never had to create four one-to-one tables
and create a form for each and make my users fill out four forms to add one
record. Yikes!

Give us some details and perhaps we can help you out.
 
I made two different versions, one this way and one with tabs. So if I stick
with the tabs do I still need to have seperate tables or can I work with just
one table? I have alot of different data to go into the table/form. For
example I have a patient name and the physician name, ID along with the type
of procedure the patient is having. I also have different check boxes for
patients info to be answered. Any help will be appreciated.....Thanks
 
Your data structure sounds flawed.

The patient data is one table. The doctor name and data is another table
(related to this main table) the procedures are stored in another table.

You need to step back and design a relational database, not a spreadsheet.
Here is an example of how this MIGHT look...

TblPatient
PatientID
PatientFirstName
PatientLastName
PatientAddress1
PatientAddress2
PatientCity
PatientState
PatientZip
PatientComments
et.

TblDoctors
DoctorID
DoctorFirstName
DoctorLastName
Inactive Y/N
etc.

TblMedicalProcedures
ProcedureNumber
ProcedureName


TblProceduresDone
PatientID
DoctorID
ProcedureNumber
DateProcedureDone
ProcComments
etc.


All of these tables would be related to eachother using the various key
fields. You would end up with several forms. One to enter, maintain
Patient records. Another form to maintain your Doctor Records. Another to
Maintiain a table of valid procedures. Another to add a new record when a
patient has a procedure performed, etc.

You need to step back and read up on relational database design and how to
construct your tables and relationships. Once you get your structure right,
then you can start worrying about the user interface (forms and reports).

Hope that gets you on the right track.

Do some searches and you will find many resources on database
"normalization".

There are also lots of good books on the topic.
 
Back
Top