Recent content by cthies

AccessBlaster Your iNput has been MOST educational. The code for the ComboBox seems to work, Now I have an issue that i can PULL DOWN the combo box and the values are present but I can not click on any of them and make them populate the field. The field remains blank. I currently have TWO...

OK, Fixed all ERRORS and the below code has no issues BUT the fields STILL DO NOT start out empty in a NEW Record. Code is as identified below: ___________ Private Sub Form_Current() On Error GoTo Form_Err Me![LastNameLis] = "" Me.Refresh Form_Exit: Exit Sub Form_Err: MsgBox...

Well, The system is accepting the code you suggested and the Debug is not finding any issues. Now, for unknown Reasons I am getting the error: "Microsoft Access can't find the field 'Liasions' referred to in your expression. The form is still populating the combo box fields when a NEW record...

ACCESS BLASTER: SOOOOOO, close Code is now as follows: ____ Private Sub Form_Current() On Error GoTo Form_Err Me![Liasions] = "" Me![Physicians] = "" Me![Hospitals] = "" Form_Exit: Exit Sub Form_Err: MsgBox Err.Description Resume Form_Exit End Sub ______ No...

THANK YOU... NoW I got a new Error, Code now looks as listed below. I added table name but the bolded and italic part now has error "COMPILE ERROR: LABEL NOT DEFINED" Also, since I have THREE combo boxes that need to be clear on start of new record, do I add three "= Null" arguments, i.e...

I am an access user that normally just uses the functionality of the software without any custom scripting or VBA usage. I was asked by a friend to create a simple database that tracks employee concerns which I did. However, there are three combo boxes that have names and other data supplied...