I have what Microsoft call a "Navigation Form" as the main form in my application. Users just click tabs to move about the application and it all works very well, looks good and was almost no work to produce.
Now one of the forms that opens when you click a tab shows a summary of overdue matters ie a continuous form of a few fields from a record in text boxes. The boxes are populated from a query that pulls out those records that are overdue for attention.
Ideally there should be a button beside the text boxes and when one is clicked it should open a form where the updating of information is needed. This happens to be the form that is opened by the second tab in the "Navigation Form".
So the VBA code behind such a button needs to be along the lines (in Psuedo VBA) of :-
Global VarID as integer 'In a Module
'and then
Sub Button1_Click
VarID = Me.ID
Click (navigation form.tab2) ' I hope its as easy as this
End Sub
'and some way of filtering the form with VarID so that it shows the right record.
This baffles me. Over to you O Great Ones!
Now one of the forms that opens when you click a tab shows a summary of overdue matters ie a continuous form of a few fields from a record in text boxes. The boxes are populated from a query that pulls out those records that are overdue for attention.
Ideally there should be a button beside the text boxes and when one is clicked it should open a form where the updating of information is needed. This happens to be the form that is opened by the second tab in the "Navigation Form".
So the VBA code behind such a button needs to be along the lines (in Psuedo VBA) of :-
Global VarID as integer 'In a Module
'and then
Sub Button1_Click
VarID = Me.ID
Click (navigation form.tab2) ' I hope its as easy as this
End Sub
'and some way of filtering the form with VarID so that it shows the right record.
This baffles me. Over to you O Great Ones!