Nit picky wee bits ...

[lynsey2]

Just about outta here guys and have a few wee bits I need to clean up... if you could help that would be great!

1.

I have a button that takes me from my search patient form to an add patient form (I simply used the wizard to do the add patient) I have taken away the record selectors but can still cycle through all of the patient details table if I want to (or by mistake). How can I get it to only allow me to enter the new details into the fields and not be able to view other patient’s info??

2.

I need search patient to stay open so I can link between forms. From search patient I HAVE got to go to Clinic Visit. The problem I am having is that if I want/need to go back to Search patient from Clinic Visit it seems to be linking and I can't see where (I don’t want to link Clinic visit>>Search patient just Search Patient>>Clinic visit) so I want to be able to go from Clinic visit to search patient and search patient open fresh!!

3.

Clinic Visit is based on the patient details table and has a sub form for all the required fields I want the sub form to start on a new record every time I come from search patient. I can get the main form to start on a new record but can’t seem to get the sub form to start on a new record. It's the sub form im using to record the details of the clinic visit.

Cheers Guys, I know this stuffs pretty basic but I can't think how to fix it.

Lyns X

 

[Tay]

Is the Data Entry property on the form set to No? If so, try changing it to Yes and then you can only add new records, and then make sure that your navigation buttons are hidden.
I hope that's what you were looking for.

 

[lynsey2]

It was yes but I changed back to no as i was trying something else and forgot to put it back to yes. Cheers Tay.

 

[lynsey2]

Any clues with 2 and 3??

I'm still half sleeping

 

[lynsey2]

Heres 2.

Private Sub CV2SearchPatient_Click()
On Error GoTo Err_CV2SearchPatient_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Search Patient"
DoCmd.Close acForm, "Search Patient"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "CV"

Exit_CV2SearchPatient_Click:
Exit Sub

Err_CV2SearchPatient_Click:
msgbox Err.Description
Resume Exit_CV2SearchPatient_Click

End Sub

closing search patient before opening it again so that it opened fresh or so I thought!
So it shouldn't link cos I dont have linkCriteria eh!????

Really stuck on 3.

 

[lynsey2]

 

[lynsey2]

any clues

 

[lynsey2]

...

 

[Hayley Baxter]

Back so soon? just can't stay away can ya

 

[Fizzio]

If you are not using the strLinkCriteria (which you don't seem to be) , then delete it from your code. It may have been set somewhere else in your code and being treated as a global variable and hence transferring across events.

ie

DoCmd.OpenForm stDocName

Thought we'd got rid of you anyway