Another calendar quesiton. I have a calendar form that selects a date. Upon selecting Ok, I am then opening the main form with records. how I go select a date and have the main form open to that record. Within the calendar cmdOk click I have:
If gtxtCalTarget = Me.txtDate Then
gtxtCalTarget = Me.txtDate
DoCmd.OpenForm "cDeposits" ', , , "([form!cDeposits.Date]) =#" & [Form]!cDeposits!txtbDATE & "#"""
DoCmd.Close acForm, Me.Name, acSaveNo
In the main form, the field that recieves the date from the calender is called txtbDate and I would like that to find that specific date record from the table field Date. Help Please