Search results

Hello, I have a main form and a subform with a list box. I want to be able to update the fields on the subform via the selection made in the listbox. I know the wizard can do this for a listbox if the fields are on the main form. I was wondering if anyone had code or can modify this code to...

Hello All, I have a listbox that I would like to prohibit users from double-clicking on a selection. The reason is because it duplicates the selected record, which is not the result I want. This is strange because I have no code in the 'OnDblClick' Event. Do you know of any tips or tricks to...

Hello, I have a problem adding a record using my current method. I have a main form with a subform. The subform consist of a listbox(single selection) and its coresponding text boxes. When the user selects a record from the listbox, its text fields reflect the record selected. I've...

Hello, Error: Expected Variable or Function I got the error message while running the following code: ************************************************* Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click Dim rs As Recordset Set rs = Me.RecordsetClone 'Check user's permissions If...

Hello, I am attempting to add a record to my tables through a form based on a QUERY. The form has combo boxes for the user to select description text from, however the tables only reference the ID of the description text. When the user selects the description without the ID, Access adds the...

Complex Query Problem (Brainteaser) Happy Friday, I have a SELECT query consisting of 5 tables (i.e. Comments, Users, ActionType, IssueType, ContactType). The main table 'Comments' is on the MANY side of a one-to-many relationship with the other tables with the following fields and...

Hello, I have an unbound password form for users to log in. When the user clicks OK after entering username and password, it then goes and matches the username with their password from the User's Table and opens another form. What I'd like to do is when the user clicks OK, to pass a value to...

Hi, I am using Access 2000 and I am having a bit of trouble trying to update a subform when the user selects an option from the listbox. The subforms were created by the wizard so the child/master fields were created successfully. The listbox was also created by the wizard with the option of...