Can't get my query to work on a form!
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am not very good at Microsoft Access's queries, they seem different than standard SQL. I have the following query:
SELECT COUNT(*) AS Total
FROM CDCopy
WHERE CatalogueNumber=[Please enter the catalogue number to find out how many copies are available];If I double click the query it shows an input box and the rest works as intended. The problem is that I don't know how to use it in a form! I have tried :
MsgBox([GETCDCopyCount]![Total]![CatalogueNumber])
Where "[CatalogueNumber]" is a textbox as I want to pass the text information from that box into the query. Keep getting error messages, can someone help me out? :-D Thanks!