Recent content by Bowmap

Also most forms (if they have a datasource) have an underlying recordset. You can access fields of the recordset by simply me!FieldName provided the field is in use in a control on the form.

Yes Dlookup is quick and easy. But, just so you know... The SQL statement should look like "SELECT Description FROM tblCodes WHERE CodeID = '" & strCodeID & "';" Assuming that CodeID is a text field you need to surround your value with single quotes. FYI a date value needs pound signs i.e...

There is also the old method of creating a macro named 'AutoExec'. That would give you greater flexibility in that not only a desired form could be your first load but also a function (not a sub) you created. Thus you could init before having to display a form.