Recent content by Steven811

Hi I have a cmd button on a form to open a new form and find a filtered record. This was alll working fine and yet now when I'm at the 1st record and use the cmd I receive the following error msg: 'Syntax error (missing operator) in query expression [fieldname]=' If I move to the second...

Cracked it Thanks for your help, worked a treat.

Don't receive the error message anymore Hi I've been looking at it again and I've put it as a line of code in the event procedure of Before Insert, the error messages have stopped although it doesn't carry the value into the foreign key field, that's a zero. Consequently I have no reference...

Error message Hi Pat I inserted [Me.ContactKey=Forms!subformContacts2!ContactKey] in the BeforeInsert section of the properties for the active (pop up) form and I get the following message: The expression Before Insert you entered as the event prperty setting produced the following error...

Hi I want a filtered pop up form to accept new records. The archive posting that I found suggested that I insert [MyForm]![LinkedField] as the default value of the linked field. Any suggestions gratefully accepted. Steven811

Code Hi smercer I've tried your suggestion, thanks. It supplies the data just like the queries, but I still can't clear the record set. Very odd. I have included a copy of the db if that helps anyone. Steven811

Thanks Works a treat, thanks.

Hi I have a cmd button on a form to launch Outlook and populate the to: field with the email address from A2k, all works fine. When the cmd button is selected and there is no data in the field an error message pops up [run-time error '94', invalid use of null]. I want to change the error...

Work around Hi I've managed to lock the cbo boxes and clear the visible fields so that a record set cannot be selected until the combo supplying the selection criterion for the query is requeried. However, I still can't clear the previous record set from the combo. This is evident from a...

Code Hi Peter Thanks for helping, this problem has bugged me for days. Question from a novice. When I run the compiler I receive the error message 'method or data member not found'. This error occurs at the line [RecordSource] [ Me.cboCust.Requery Me.cboCust.Locked =...

Hi I have a form with 4 combo boxes. The code that I use works correctly when I first open the form. There after if the form remains open and I select new records the next cbo filters correctly but the subsequent cbo retains the previous record set until it's parent is selected. The combos...

Requery code Hi Ecniv The code clears the fields as it should however, the 3rd combo retains the record set from the previous selection. If you look at the record counter of the 3rd combo, this remains unchanged. This problem seems to affect the next but one combo. Which ever one is...

Hi I have attached a stripped down version to demonstrate my problem, you will also see an example of the cascading combo boxes that I have created with the assistance of mile-o-phile's examples. When I have been through the combo boxes once and made my selection everything is fine. When I go...

Hi I have form with 4 cascading combo boxes and if you filter down after the form has opened they work fine. If the combo boxes have records and you go back to the 1st combo and choose another record, the 2nd combo correctly shows the selection and the 4th combo is cleared and locked as it...

Thanks Works a treat, thanks.