Mimic splitform without using splitform...

[MackMan]

Hi guys.

I was wondering if there was a way to mimic a split form view, using my own design.

In other words..

I have one form with 2 subforms. The top subform is used to enter data.
The bottom subform shows ALL records, based on a query.

What I have set up so far is...

On the bottom sub form I click a record, and using

   Dim lngID As Long
   lngID = Me!TopLineID
   [Forms]![frmmain]![frmMainTopLines].SetFocus
   [Forms]![frmmain]![frmMainTopLines].Form![TopLineID].SetFocus
   
 Docmd.findrecord lngID

I can highlight the record in the top subform from the bottom one..

All works wonderfully.

Now What I'd like to do (like a split form) is just to highlight that record in the bottom subform if I'm editing it or scrolling though the top subform's records.

Is this possible? If so, how?

Many thanks...

 

[spikepl]

http://lmgtfy.com/?q=access+two+related+subforms

 

[MackMan]

Thanks for that. Please don't think I've not tried searching for a solution to this. I'd much rather do so, than come straight here asking you guys. I appreciate how busy you all are.

I already use a method like this in other forms.
However, like a "split" form, I'd like the bottom datasheet form to show all records... but just highlight (change the background colour) of the one I'm editing or viewing in the top subform... not filter all records in the bottom subform to view just the one...

 

[JHB]

... but just highlight (change the background colour) of the one I'm editing or viewing in the top subform...

Then you need to use conditional formatting.

 

[MackMan]

JHB Thank you.

I am currently looking into how this will work.