Setting the default value in a textbox 1

[KalEl33]

I am having trouble setting the default value in a textbox called txtDate on a form I call frmConfirmUpdate. I want to fill the textbox with the Date from my table called tblData which contains the Date and a unique identifier called MonthlyID. I would like to enter the MonthlyID into a textbox called txtMonthlyID and have the textbox (txtDate) display the corresponding Date. My best guess as to how to do this is to enter the following into the textbox's Default Value property:

=(SELECT [tblData].[Date] FROM [tblData] WHERE ((([tblData].[MonthlyID]) = Me![txtMonthlyID])))

However, I get the following error: #Name?

Any ideas on what I'm doing wrong?

Thanks in advance.
Kal-EL

 

[paron]

I think you want the DLookup function. Check out the following from Access help.

The following example returns name information from the CompanyName field of the record satisfying criteria. The domain is a Shippers table. The criteria argument restricts the resulting set of records to those for which ShipperID equals 1.

Dim varX As Variant
varX = DLookup("[CompanyName]", "Shippers", "[ShipperID] = 1&quot

Instead, yours might be: DLookup("[Date]", "tblData", "[MonthlyID]) = " &Me![txtMonthlyID])

Personally, I use Comboboxes in preference to DLookup -- they seem to be much faster. Bind to [MonthlyID] and set Rowsource to a query with the first field MonthlyID and the second [Date].

 

[KalEl33]

Paron,

Thanks for you help. It worked wonderfully!

Sincerely,
Kal-El