Originally I had populated the following as my control source:
Code:
=DLookUp("version","qryversionlist")
. "Version" is from tblVersion, not my main table. The problem is that I need a field in my main table as the control source, and apparently, I can't have both a field and the dlookup as the control source.
qryversionlist brings up the most recent version number:
Code:
SELECT TOP 1 version
FROM tblVersion
ORDER BY id DESC;
I need that value to be in the default value for my field on my main table so it will always show up on my form, but can't figure out how to do it. I read that you can do it with a query, but how do I enter the query into the table field?
Thank you,
Brad