Opening Forms

[.Justin]

Hi I have made a very basic, simple medical database for a Voulentry Medical Provider. It allows the user to book in a patient at reception and then be followed in triage and treatment to be recorded.

The form is a pop up from a custom made switch board and does have tabs. The problem i have is once i have saved the details ontot he form and then close that form i can not go through past records on the form it just shows record 1 of 1 when there is about 1 of 15. Whats going on? Is it somethign simple that i can resolve?

 

[pbaldy]

I'd guess that either the Data Entry property is set to Yes or it's being forced into that mode when it's opened.

 

[.Justin]

Data Entry is set to No.

I also meant to add that when you open the form it automaticly goes stright back to record 1 with all the details on it not a blank form.

 

[pbaldy]

What is the code to open the form? Is there any code in its open or load events? It sounds like it's getting filtered somehow.

 

[.Justin]

Its a simple Macro:
Form Name: Add Details To EPR
View: Form
Filter Name:
Where Condition:
Data Mode: Add
Window Mode: Normal

I have also tried Data Mode in Edit

 

[pbaldy]

Data Mode: Add

will cause it to open to a new record, without displaying existing records. What happens if you change that to "Edit"? Presuming there's no code in the open or load events, and no previous filter saved, "Edit" should open it to the first record with all other records available (1 of 15).

 

[.Justin]

Nope still opens on the frist record and shows one of one... Could it be releationships?

 

[pbaldy]

Can you post the db?

 

[.Justin]

Yer sure
User: JWilliams
Password: avon

you will need to hold down shift when opeing it to get the nav bar up

 

[pbaldy]

I think your question about relationships is correctly identifying the problem. The query underlying the form only returns one record. You can change all the joins in that query and it will then pull all 4 records. That said, I'm not comfortable with the overall design. I have to head out for a while, but I'd research "normalization", starting here:

http://www.r937.com/Relational.html

Generally, I'd expect the other tables to have one-to-many relationships with the primary information table, and be represented by subforms within the main form, rather than one all-encompassing query. You also don't want fields for possible items, you want records. I'm specifically looking at the treatment table, but it may apply elsewhere as well. Gotta go, but start with that.