Hello, I hope somebody can give me some help.
I created a system in Access to catalogue my banknotes.
One of the features is to display a country profile from a form (frmCountryProfiles), then view the country's banknotes by selecting "View Banknotes" which opens form (frmSelectedCountriesBanknotesV3), see Attachments A and B.
This is the command used when "View Banknotes is selected: DoCmd.OpenForm "frmSelectedCountriesBanknotesV3", acNormal, , "Country_Code = '" & Me.Country_Code & "'"
So far every thing works fine.
I recently decided to add a Countries Index form, see Attachment C.
The idea is to select a country this would call Country Profiles and display the selected country, then call Selected Country Banknotes as above.
I cannot get this to work.
I have used the following examples to open form (frmCountryProfiles) from form (frmCountriesIndex), see Attachments F and G.
On Attachment G both OpenForm commands do not work, the first example gives a syntax error in string ,the second causes the program to exit and return to This PC > Documents.
If you need more information, I will supply.
Thank you for any help.
Denis