Recent content by johnhobbis

I have a form with a sub form the sub form has multi records ie: Main form Client details x 1 Sub form Client orders x 20 At the moment when i click next record it just goes to the next sub record and doesnt seem to go anywhere until i click 20 times on the next button on the main form, this...

I have a present a Toggle button that changes from AT RISK to NOT AT RISK using the following VB =========================== Private Sub Form_Current() If Me.At_Risk_Register.Value = True Then Me.At_Risk_Register.Caption = "AT RISK" Else Me.At_Risk_Register.Caption = "NOT AT RISK" End If End...

Would like a sample please. Regard John

Unfortunately, When I implement this change the opening form comes up completely blank.!! just the background, i go to design mode and the form is there?? ============================================ Private Sub DISCHARGE_Click() Forms![frm_HDUITU_followup]!At_Risk_Register = False 'open the...

The VB closes the form and opens another, but I have a ID on the form [frm_HDUITU_followup]I am Closing. I want to go straight to the same ID on the form [frm_MainDischarge] that I am opening. ============================================ Private Sub DISCHARGE_Click()...

Ian, Thanks a lot am learning fast....... Just change the toggle to the front because it triggers form the form that is being closed. Thanks alot.

I have tried this but come up with an error 2501 every time.......... Any Ideas Private Sub Print_Record_Click() Dim strDocName As String Dim strWhere As String strDocName = "Rpt_followup_visit_small" strWhere = "[OutreachID]=" & Me!OutReachID DoCmd.OpenReport strDocName...

I am trying to get a button to exit a form then open another form at the same time change a yes/no toggle. Is this done in the query and from or just in the form. [This message has been edited by johnhobbis (edited 04-15-2001).]

Carol, Am mailing you a screen shot and details, The outreachid are ok . i just need to increment the Visit Number in the Sub Form for a patient visit the sub form might have a number of the same outreachID (patient number) depending on the number of visits.

Hi Carol The OutreachID on both Master and Child (subform) are ok. But when i add a record to the SubForm i need the Visit_Number to increment by one for every record added to the SUB FORM. Can send you over a screen shot of form if you like.

Hi Carol The OutreachID on both Master and Child (subform) are ok. But when i add a record to the SubForm i need the Visit_Number to increment by one for every record added to the SUB FORM. Can send you over a screen shot of form if you like.

I have a subform with a field called "Visit_Number" the subform has a related childfield to the masterform OutreachID Master(autonumber) OutreachID child. I need to add a record to the subform that keeps the current OutreachID (master) this works ok. BUT I need the Visit_Number field to...

ABBY Can you send me the examples again, with them attached. Got your mail but no attachment? Regards john@hobbis.karoo.co.uk

I have a print button on a SubForm and when pressed it prints all the Records in the subform... Any idea who to resolve this. John H.

Abby that would be great..... Thank you. john@hobbis.karoo.co.uk Thank you..... Regards John