is it possible

[Guest]

is it possible to have a symbol on an access data base that when you click on
it it will go to another pager and visa versa???????????

 

[Guest]

Do you want to go to a specific page - or the last - the previous - 1st -
last - etc.

Or
Do you want to go to a specific "record" which will have a primary field.

Bit more info please

 

[Guest]

it is to go from a data base to a specific report

 

[Guest]

Hi Dave

Yes no worries

You could say from a form use something like

Private Sub ButtonName_Click()
DoCmd.OpenReport "ReportName", acViewPreview, "",
"[ReportField]=[Forms]![FormName]![FormField]", acNormal
End Sub

This would open a report to a specific "record" - this could be a reciept or
a letter, etc.

Like anything else making code work in the way you want takes a while. Can
I suggest you look at using a Macro (somepeople don't like them but they do
have their uses).

Open a new macro and select open report from the drop down list
then simply enter the criteria.
Save the macro and place it behind an OnClick event of a button

Hope this helps

 

[Guest]

Sorry - typo

"[ReportField]=[Forms]![FormName]![FormField]", acNormal

Should be
"[ReportField]=[Forms]![FormName]", acNormal

ooops