Search results

Hi, thanks for the responses, code below: If Me.Dirty = False Then MsgBox "No changes have been made or have already been undone/saved.", vbOKOnly, "Information" Else DoCmd.RunCommand acCmdUndo MsgBox "Changes have been discarded.", vbOKOnly, "Information" Me.Dirty =...

I have a form with an undo button which works fine...sometimes. the issue is if the user hasn't clicked out of the text box they have updated before clicking the undo changes button only the changes they have made to that text box are un-done. my question is when the user clicks the undo...

Hi All, have tried above suggestion but still no joy. Please see my complete code for the open event of the parent form. it nearly works but for some reason once its found the selected record it jumps to the end of the recordset to the add new record. Dim bpidopar As Long Dim siidopar As Long...

Hi, I'm already using openargs on the form. I pass two variables as one (bpid and ssid) and then split it. The bpid works fine, I use it as part of the master/child link to restrict the subform to the particular business. I just can't get the subform to go to the correct ssid record. Well as...

Hi thank for baring with em on this, my database has 3 tables: customer details, customer business and customer business interactions a customer can have many businesses and a business can have many interactions. when the user clicks on the record id of a business interaction they want to open...

Hi, Correct. If the user selects related record 20 of 30 then the subform will only show record 20 with master/link selected. The user can not cycle through the other 29 records.

Hi, thanks for the response. If I use the master child link it does work but it doesn't allow the user to cycle through the related records. They only get record 1 of 1 rather than e.g 1 of 20.

Hi, i have a form with a nested subform that are opened from a mainform. When the user selects a specific record on the main form i want the form to open and the subform to display the selected record. I am using the below code on the load event of the form: when i first run it it works! the...

I thought i had it working! I added the below code to the on load event of the parent form and when i first run it it worked! the nested sub from displayed the correct record and did so for the next few that i tried. There were 10 related records in this example and after number 4 it stopped...

I have tried adding the siid to the master/child link which does work in that it opens at the specific record but it then doesn't allow the user to cycle though the related records.

Hi, I have a main form and a nested subform. The main form is based on customer details and displays customer name and the customer primary key (custID). When this form is opened i pass two parameters to it, BPID and SIID. A BP is a business picture and a SI is a sales interaction. These are...

HAHA SUCCESS!! thanks so much for your help

Hi, It does nothing

I have subform withina main form that displays records. I have a save and close button on the subform that when cliked i want to close the mainform thereby saving the record. However i cannot get the main form to close. this is my code, any help? If Me.Dirty = False Then MsgBox "No...

I have come up with a solution not sure if its the best way but it works :) i have set the reocrd source of the pop up form as the customer table and added the customer records as a subform. the popup form is opened from the main form by double clicking on a selected record and the recordid is...

I firstly want it to restrict to the record (which it does) and secondly restrict to the customer so a user can view the rest of that customers records. This is what I can't get to work.

double click event: DoCmd.OpenForm FormName:="popformQCustomerBP", OpenArgs:=Me.BPID form load: Dim rst As DAO.Recordset If Len(Me.OpenArgs & "") > 0 Then Set rst = Me.RecordsetClone With rst .FindFirst "BPID = " & Me.OpenArgs If Not .EOF Then Me.Bookmark = .Bookmark...

I thanks for replying. To clarify: I have a main form based on customers table (PK custID). This form then has a sub form based on customer records (PK recordID). The subform is linked to main form on custID. When a user selects a customer on the main form the subform updates showing all...

I have a sub form in datasheet view that displays all of a customers related records. I have set a double click event on one of the subforms fields thats opens the selected record in a popup form. I currently have this working using openargs (recordID) I want the user to be able to use the...

Hi, thanks for responding. I've tried this and it used to work but no longer! I have a subform which then includes another subform on a tab control. in datasheet view when i used to expand the 2nd subform it used to auto include the 1st subforms primary key which i could then pass to my pop...