Recent content by MiAs

Thanks for the advice GRNZBRA I will give it a whirl

Sorry,to make it clearer. I am basically getting the results I want but they are duplicated,5 fold in some cases. I have currently got the tables linked by Reporting Person with 'joined fields from both tables equal' Is my problem a table relationship problem

Hi, I am trying to make a query from fields out of 3 tables. All tables must include following fields: Table 1 fields: WR04 (year 2004) Date Reporting Person Table 2 fields: WR05 Date Reporting Person Table 3 fields: WR06 Date Reporting Person I am trying to pull together in the query any...

Thanks for your help FoFa I managed to get it working with the & "*" criteria

Thanks for reply Fofa but can you make it more simple as I haven't your programming skills!

I have a form with several fields where a ref number such as AB1234 may be entered in one field but this ref number may also be entered in another field referring to another order. Using 'Like[RefNumber]' as a criteria is only returning ref number from one field when same number may be in...

Thanks for that Stef, You were right, control source problem with EthnicOrigin. :D

Code: cboNumber1_AfterUpdate() Me.txtPerson1 = Me.cboNumber1.Column(1) Me.txtEthnicOrigin1 = Me.cboNumber1.Column(42) Bound to Column 1 table field 1 = Number table field 2 = Person, table field 43 = EthnicOrigin I had this running ok until importing fresh table data now I get run-time error...

Table field (primary key) data type:Number How can I validate / symbol as in 05/01 representing year and 1st record, etc. Many thanks in anticipation.

Problem sorted. It was a code error that was strikingly obvious in the end,don't know how it ever worked as well as it did!! Thanks to all who contributed. ;)

What do you mean by Reset References?

When trying to compile, as mentioned I get error message:Method or data member not found. I have several txt-cbo boxes on form Private Sub cboSurname1 AfterUpdate() Me.txtNumber1=Me.cboSurname1.Column(1) End Sub The highlighted bit is .cboSurname1

I will try Windsailors suggestion and re-create the form which appears to be causing the problem. Unfortunately I do not have access (pardon the pun) to the db now as it's at work so I will continue tomorrow UK. The db contains sensitive information and has to be renamed with innocuous items...

Tried & failed. When running the debug - compile,as I mentioned I get an error message:Method or data member not found. When O.K.ing this message a section of code is highlighted in blue which is part of a txtbox-combobox setup on a form,the txtbox reading from the cbobox to autofill. This...

Importing everything into a new blank db, won't that import the problem also?