laht0028
Last Activity: Jun 20 '16, 01:40 PM
Joined: Sep 21 '15
Location:
-
The data type is numerical. The first column is the primary key of the table of interest. -
Error 3464, data type mismatched
Hello,
I'm attempting to use a combo box to search a list in a subform. I have the following code but when I attempt to use the combo box I get and error (Error 3464 in setting subform filter: Data type mismatch in criteria expression)
...Code:Private Sub cboGWStaff_AfterUpdate() On Error GoTo Proc_Error If IsNull(Me.cboGWStaff) Then Me.SearchRecords_Subform.Form.Filter = "" Me.SearchRecords_Subform.Form.FilterOn
Last edited by Rabbit; Oct 6 '15, 04:24 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
I'm finding that if I have all the fields filled out then the records appear in the subform. If one of the fields from one of the tables is not filled out then the subform will not show that "incomplete ly" filled out record. I don't care if all the information is not there. I want to be able to see any available record information. Thank you again for your assistance!Leave a comment:
-
Searching using a combo box
Hello,
I've been attempting to create a form that uses a combo box to search the form's subform (see link for the guidance I've been following: https://www.youtube.com/watch?v=8N1hRBd sI1s). If I select an existing table to populate my subform then it shows foreign key numbers for some of the fields rather than showing the common names (the tables are relational). If I create a subform and select fields from multiple tables then I am... -
Creating a searchable combo box
Hello,
I am attempting to create a form with a combo box that searches a subform and I have been using the following link as a guide (https://www.youtube.com/watch?v=8N1hRBd sI1s). When I set up the subform to contain fields from several different relational tables I am unable to see the populated records in the Layout view. If I use one of the tables (which contain only numbers for the foreign keys that I do not want users to search... -
I just realized that they are unbound. I was able to "bind" these combo boxes and now it works beautifully. Thank you so much!Leave a comment:
-
Thank you! I was able to use this code to clear the combo boxes in my form. Unfortunately it doesn't appear to retain the information if I move to a new record, even if I have "saved" my form inputs using a save button. Are either of you familiar with why my text box information is saved while the combo box information is not?
Thank you again for your time and expertise!Leave a comment:
-
Clearing multiple combo boxes on a form when proceeding to next record
Hello,
I'm attempting to create a form where the multiple combo boxes are cleared when I proceed to the next record. I have applied the below code and it works to clear one of the combo boxes but not any of the others. I have applied this to each combo box by going to Properties -> Event tab -> On Click -> [Event Procedures].
Any help is greatly appreciated!
...Code:Private Sub Form_Current()
Last edited by Rabbit; Sep 21 '15, 09:22 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: