Recent content by Wolfryder88

You can use the DatePart() function to validate your date. You could certainly build an [event procedure] on the BeforeUpdate event of the field, or possibly as part of an expression in the validation property.

Does your combo box have a recordsource? If it (or any other control) is not bound to a particular field the combo box selection won't be saved when you move to another record.

I'm getting closer to solving my puzzle. Using Keyup works (since it occurs after the Change event?). Now I'm stuck with a loop if there are no search results, since a message box appears to tell the user such, and entering thru the message box triggers the Keyup . . oops). But this will...

You can combine firstname and surname in your combo box. I'm assuming your current combo box is pointing the [surname] field in a table? Instead, create a query; add the firstname and surname fields (and your primary key field); next, create a new field: Fullname: [surname] & ", " &...

I have a continuous form with an unbound text box (for search critera) and a command button to kick off the search, which simply applies a filter. When a user enters text in the unbound text box and hits "Enter", I want the search to be kicked off (instead of having to tab over or mouse over to...

Your structure looks good to me. At first I questioned the need for the PaperworkOptionID in the tblPaperwork, but then re-read your problem - changing paperwork requirements. Makes sense. You're right, you'll end up with lots of records in tblPaperwork. You'll need to be comfortable with...