I may be going about it wrong, but...
I think I need help creating a SQL string which will open a record from a table and look for certain fields and apply them to variables I created.
I keep getting a Data conversion Error...
My code:
Dim Job as string
Dim Builder as string
Dim Plan as string
Job = Me.JobEntry.value ' Custom dialog JobSearch with TextBox 'JobEntry'
SQLstring = "Select * From [Set Up] Where [Set Up].[Job Number] ='" & JOb & "';"
'This works in my Cad VBA, I guess Access is different?
Set Jobrs = currentdb.openrecordset(sqlstring, Dynaset)
'I get conversion error here....I assume my Sql string is wrong...
I do have my form run a query and bring back the record of whatever JOb# is in the JObEntry textbox.
Access VBA uses the statement...
Docmd.openquery stDocName, AcNormal, AcReadOnly
Can I access the other fields from this and apply them to my variables?
?
I'm new to access so I may very well be way off course....
oh, I hope this is the correct area for this Question...