This is my menu under form load
Private Sub Form_Load()
mnuBook(0).Caption = name in first recordset
Load mnuBook(1)
mnuBook(1).Caption = name in second recordset
Load mnuBook(2)
mnuBook(2).Caption = name in third recordset
Load mnuBook(3)
mnuBook(3).Caption = name in fourth recordset
Load mnuBook(4)
mnuBook(4).Caption = name in fifth recordset
End Sub
i have seen this done in some programs. as soon as the user enters a name in the first record of the addnew form which is linked to a database and you open this second form with the menu shown above, the name he entered should show in this menu caption. the user does not have the option to enter the menu caption..only the name can be entered by the user in the addnew form...in turn this name entered is saved in the database and this code shown above picks the correct name from the database and enters it as the menu caption in another form...does this make sense?? what code would i put in the above formload to pull that name from the database and insert in in the menu caption??
