Sub form not working in a navigation form

[MAAS8000]

I have a form contain 4 combo boxes used to filter a query
it all working well
when I used this form as a sub form in a navigation form and try to run the query, access request the value of the parameter

 

[MAAS8000]

my form is "FrmOldTransaction"
navigation form is "Dash board"

original code : Like [Forms]![FrmOldTransaction]![CboPatientData] & "*"

edited code: Like [Forms]![Dash Board]![FrmOldTransaction]![CboPatientData] & "*"

also not working

 

[MAAS8000]

my problem is like in this post

https://access-programmers.co.uk/forums/showthread.php?t=263872

i have tried the solution there but it is not working also

 

[JHB]

Post your database with some sample data, (do a "Compact & Repair" + zip it).

 

[MAAS8000]

my form called : FrmOldTransaction
it also in the navigation form : dash board

the button : retrieve old transaction work in the form only not in the dash board
it need me to enter the parameter

 

[JHB]

Try it now:

 

[MAAS8000]

thank you it, working now
Q: I have three parameters in the query to be filtered by the combo box
the last one is the transaction date
i could not make it like &"*" to avoid if the combo box is blank
can you help me


Between [Forms]![Dash Board]![NavigationSubform]![CboFromDate] And [Forms]![Dash Board]![NavigationSubform]![CboUpToDate]

 

[JHB]

..Between [Forms]![Dash Board]![NavigationSubform]![CboFromDate] And [Forms]![Dash Board]![NavigationSubform]![CboUpToDate]

You could fake it a little:

Between Nz([Forms]![Dash Board]![NavigationSubform]![CboFromDate];0) And Nz([Forms]![Dash Board]![NavigationSubform]![CboUpToDate];#01-01-3100#)

 

[MAAS8000]

Good,but I faced a new problem
for the transaction number I made this

Like [Forms]![Dash Board]![NavigationSubform]![CboTransNum] & "*"

so when the combo box is blank it retrieve the all transaction
the problem that when I request transaction number 1
it gives me 1 , 11, 12, 13, etc
so i tried two ways but both didn't retrieve any thing when combo box is blank


IIf([Forms]![Dash Board]![NavigationSubform]![CboTransNum] Is Null,"",[Forms]![Dash Board]![NavigationSubform]![CboTransNum])

N.B. i tried to put star "*" also not work
Nz([Forms]![Dash Board]![NavigationSubform]![CboTransNum],"")