'Showing related data on opening a new form' What about getting it all up?

[sithius]

Well basically I have a form with a button on it and some fields. The button brings up another form with that related data of the current record already on display. (Did all this using wizard)

How can I get it to show the related data but also have access to the rest of the data that isn't related? Will this require some VBA?

For example, if I have customerID 1 it'll bring up the related records for 1. But I want it so I can also go onto the next record and see data relating to customer 2.

All help appreciated.

 

[sithius]

No one? I really need help with this.

 

[rainman89]

Do you have the second form based off of a query? or is it just opening up with a filter?

 

[Epic]

add a button say btnToggleFilter with the text "Show all" and in the on click event add:

select case Me.FilterOn

Case True
Me.FilterOn = False
Me.btnToggleFilter.Caption = "Show initial"
case False
Me.FilterOn = True
Me.btnToggleFilter.Caption = "Show All"

end select

you can additionaly add under True case a Find before turning off the filter, a statement to search for that record as when remove the filter the cursor will jump to the first record

Hope that helps.

 

[sithius]

add a button say btnToggleFilter with the text "Show all" and in the on click event add:

select case Me.FilterOn

Case True
Me.FilterOn = False
Me.btnToggleFilter.Caption = "Show initial"
case False
Me.FilterOn = True
Me.btnToggleFilter.Caption = "Show All"

end select

you can additionaly add under True case a Find before turning off the filter, a statement to search for that record as when remove the filter the cursor will jump to the first record

Hope that helps.

Cheers. Works fine.