Recent content by Steven811

Thanks for your help gents. I opted for Ken's solution as I thought it would be easier and it works a treat. V Grateful.

Hi I have a column containing 1200 records that I want to convert into a table in Excel so that I can clean it up and export it into Access. The data looks like this: A1:Name A2:Address1 A3:Address2 to A10: sometimes the last 2 0r 3 fields are empty etc and I want it to become: A1:Name...

Cracked it. Thanks for the helped gents.

Sorry if I haven't explained my self. That is what Ive done, I've checked the references too. My actual code is: Private Sub Form_BeforeInsert(Cancel As Integer) Forms!forProject2.ContactKey.Text = Forms!subformContacts2.ContactKey.Value End Sub My error msg says that Access can't find...

Hi I receive the error message that it can't find the main form (although in my case it is a subform) Steven811

Hi I need the foreign key value to update when I enter a new record. I've tried setting the default value to the primary key value of the parent form and that didn't work. I've also had the suggestion of setting the BeforeInsert event, I used the following code here and this didn't work...

Hi Both the parent and child forms are linked to different queries.

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

Thanks, I'll work on this tomorrow am and let you know. Regards Steven811

Excellent, thanks Works a treat:))

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

Hi You are correct, the combo boxes act as a filter for the subsequent cbo. The record is the criteria used in a SELECT query, this all works fine. The problem that I have is that once I have used the form the records don't clear in the 2nd level combo boxes until the parent combo is...

Hi I've tried to make your code work and I can't. I swapped the [>] plus the False and True and on the second selection it greys out the subsequent cbo. Doesn't seem to matter which way round they go. In spite of my best (although still limited) efforts I have reverted to my previous code...

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

Hi They're queries. Thanks