If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update record
After a the following code opens a second date box when
required, when I move to the next record, the box is still open. What do I add to the code? Any help gratefully accepted! Thanks Brian Private Sub Attended_AfterUpdate() If Attended = "Rebooked" Then seconddate.Visible = True ElseIf Attended = "DNA" Then seconddate.Visible = True Else seconddate.Visible = False End If End Sub |
#2
|
|||
|
|||
Update record
On Fri, 9 Jul 2004 07:01:34 -0700, "Brian"
wrote: After a the following code opens a second date box when required, when I move to the next record, the box is still open. What do I add to the code? Any help gratefully accepted! Thanks Brian Private Sub Attended_AfterUpdate() If Attended = "Rebooked" Then seconddate.Visible = True ElseIf Attended = "DNA" Then seconddate.Visible = True Else seconddate.Visible = False End If End Sub If I understand you correctly then use the form's On Current event. Like ... Private Sub Form_Current() Me.seconddate.Visible = Me.Attended = "Rebooked" Or _ Me.Attended = "DNA" End Sub - Jim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
update records | Mjohnson | Running & Setting Up Queries | 3 | July 19th, 2004 05:05 PM |
Update existing Record and create new record | bdehning | General Discussion | 2 | July 5th, 2004 06:46 AM |
Update another table with a Max record query | Ngan | Running & Setting Up Queries | 2 | June 22nd, 2004 05:01 PM |
Update Query specific to Record | Kim | Running & Setting Up Queries | 5 | June 16th, 2004 03:24 PM |
Update query based on value in a different record of the same table | Dale Peart | Running & Setting Up Queries | 2 | June 9th, 2004 12:53 AM |