Recent content by tdannay

Hello, I have a combobox that contains options for "Faculty", "Students", "Staff", "Other", and "(All)" via a rowsource query that looks like this: SELECT "*" As userTypeKey, "(All)" As userType FROM userType UNION SELECT [userType].[userTypeKey], [userType].[userType] FROM userType...

Thanks! That worked perfectly. I knew there had to be a way that I was overlooking.

Please excuse my double-post. I just wanted to share that this explanation seems to be the same thing I'm experiencing: social.msdn.microsoft.com/Forums/en-US/accessdev/thread/58a2a9e0-2623-4488-8434-a21f733c35ed/ If this is indeed a bug and not an error on my part, what workaround would you...

The following code is in the Form's 'On Current' and 'After Update' events, as well as in the combo box's 'After Update' event: If userType = "Student" Then Me.title.Visible = False Me.departments.Visible = False Me.location.Visible = False Me.phoneNum.Visible = False Me.projLevel.Visible =...

Thanks for your quick response! The row source for the combo looks like this: SELECT userquery.personKey, userquery.lastName & ", " & userquery.firstName AS Expr1 FROM userquery ORDER BY userquery.lastName & ", " & userquery.firstName; There shouldn't be anything special about the first...

Hello, I'm skipping an introductory post on the forums for now, and I'll go back to it soon - first I wanted to ask for help! The following is a problem I was unable to find in past posts on this forum, or elsewhere: I have a form with a combobox and a series of text boxes. Depending on the...