Heatshiver
Registered User.
- Local time
- Today, 06:48
- Joined
- Dec 23, 2011
- Messages
- 263
I have a combobox on my main form and simple code for its AfterUpdate event:
Me![Days].SetFocus
DoCmd.FindRecord Me!cboPDates, acEntire
Row Source:
Field - Expr1: Days
Criteria - Is Not Null
Field - Expr2: User
Criteria - [Forms]![frmUserID]![UserID]
This used to work flawlessly. It would display the the UserID and the dates they had already used. A user could then choose a date and it would display any and all information for that user and date in the fields below.
Now, it doesn't work at all. You can see the UserID and dates just fine, as well as select one, but nothing appears in the fields below...
I have other forms using this exact same code that work, they use subforms. I tried a subform for the form in question without success. The only difference between this form and the others is that this form uses the main table (that contain Days and User), while the other forms only reference the main table through a foreign key.
What is going on? How can I fix this? Thanks for the help!
Me![Days].SetFocus
DoCmd.FindRecord Me!cboPDates, acEntire
Row Source:
Field - Expr1: Days
Criteria - Is Not Null
Field - Expr2: User
Criteria - [Forms]![frmUserID]![UserID]
This used to work flawlessly. It would display the the UserID and the dates they had already used. A user could then choose a date and it would display any and all information for that user and date in the fields below.
Now, it doesn't work at all. You can see the UserID and dates just fine, as well as select one, but nothing appears in the fields below...
I have other forms using this exact same code that work, they use subforms. I tried a subform for the form in question without success. The only difference between this form and the others is that this form uses the main table (that contain Days and User), while the other forms only reference the main table through a foreign key.
What is going on? How can I fix this? Thanks for the help!
