Search results

Hello WayneRyan, You were the one who helped me with this on a previous post. ListBox Not Updating on Subform Your solution worked for a while until I noticed that clicking on a selection would duplicate that selected record in the underlying table. I've then tried to make the subform unbound...

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...

Thanks for the response guys, DJN: It actually adds a duplicate record into the underlying table. Mile-O-Phile: I don't have any code in the OnDblClick Event or the Click event, that is what makes it so strange. The only code I have is in the AfterUpdate Event. Here is the code I have...

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...

GumbyD, I thought I would explain the full scenario for better clarification: I have a Main form with a subform that will display comments about the record being displayed at any given time. Within the subform, I have a listbox that displays comments already recorded by on a record. When 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...

Works like a charm...Thanks very much.:)

Hey Mile-O-Phile, Will this method work with unbound forms?

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...

Nevermind, I deleted and re-inserted the control that wasn't updating and now it works. Thanks for your help! Life is good now.

Yeah, I've been having alot of 'unexplainable' issues with this subform. This is one of many of it's type and when I tried your suggestion on other subforms of it's type and it worked like a charm. However the fields would only reflect the first record the user selected and will not update...

WayneRyan, I've inserted the join field on the main form AND on the subform AND it is listed on the listbox. Am I missing something?

WayneRyan, Thank you for your timely response. It seems that your solution will work nicely. However, when I used the OnClick event of the listbox, I get the following error: Cannot add record(s); join key of table 'MyTable' not in recordset. Any suggestions? Thanks in advance

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...