I have two tables A and B. There is a 1 to many relationship between A and B. Table A's data is controlled by FormA, Table B's data is controlled by FormB which is a subform on FormA. I already have a combo box for navigation on FormA, however I would also like to be able to have a combo box on FormB (FormA's subform) for navigation, so that when I choose an record from the subforms (FormB) combo box, FormA then jumps to the 1 record from FormA that contains the related record choosen in the SubFormB's combo box (at the same time as the subforms choosen record on the subform) .

Kindalike the combo box on FormA, except it's a 'reverse lookup' if that makes sense. Is this at all possible, does this even make sense?

Basically it is not a good idea.

If you need this way then there is no meaning of one-to-many relationship. I would suggest one way only.

Ashfaque

So basically you want an internal Search function on the subform that will lookup a record from Table B and display it, plus its 'parent' record in Form A? If so, is it truly a one-many relationship (each Table B entry corresponds to one and only one Table A record?) or is it a many to many (Table B record may be related to multiple Table A records).

I mean really, it's programmable if it's the functionality wanted (I know that 'what is wanted' seldom matches up with 'what is good design'). The code would go on the 'On Click' event for a button such as 'Go' or whatever next to the combo box. The gist of it would be something like:

'Store the search parameter in a variable (VarB)
'Create query on Table B to bring up the record searched for
'Make query into a recordset
'If recordset not empty then
  'Store the value in the recordset's field referring to Table A in a variable (VarA)
  Me.Parent.RecordSource = "SELECT * FROM TableA WHERE Id = '" & VarA & "'"
  Me.RecordSource = "SELECT * FROM TableB WHERE Id = '" & VarB & "'"
  Me.Parent.Requery
  Me.Requery
'End If

You might have to remove any master/child links and manually program it in, I'm not sure how well they play along with code that's basically backdooring the database into doing what you want.