My database frequently has 2 records per household: a "Main" record for one of the adults and a "Companion" record for his/her spouse.

When I'm working (in search/update mode) on one of the records, I want to be able to click on a command button to take me to the "alternate" record.

In other words, if I am in the Main record, I want to click on the command button to take me to the Companion record.  Likewise, if I am in the Companion record, I want the command button to take me to the Main record.  I want to be able to click and alternate between the two records as often as necessary.

For some reason, I cannot visualize an appropriate approach to doing this.

Suggestions will be appreciated.

Hi Steve -

I'm sorry for not being more specific.  No, one is not a subform of the other.  

The database only has one form (which consists of 6 tabs).  I need every item of all 6 tabs for each of the individuals.  (I had considered sub-forms but it would not work in this instance).  

When I am looking at the information about one of the spouses, I almost always need to access the same information about the other.

Perhaps if I shared my solution in Access, it might generate some ideas for a Sesame solution.

I use 2 fields (layout elements) on each form to accomplish what I want.  One field is ID (a unique system generated "number").  The other field is Alt ID.  So, if one person's record was ID number 63 and the other persons ID number was 104, each record would "point" to the ID number of the other record in the Alt ID field.

In other words, the record with ID number 63 would show an Alt ID of 104.  The record with ID number 104 would show an Alt ID of 63.

The command button was programmed:

Private Sub FindCompanionForm_Click()
On Error GoTo Err_FindCompanionForm_Click

   Dim stDocName As String
   Dim stLinkCriteria As String

   stDocName = "frmContact"
   
   stLinkCriteria = "[Alt ID]=" & "'" & Me![ID] & "'"
   DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_FindCompanionForm_Click:
   Exit Sub

Err_FindCompanionForm_Click:
   MsgBox Err.Description
   Resume Exit_FindCompanionForm_Click
   
End Sub


I hope that this better defines what I am attempting to do.

If at all possible I would like to do it using Sesame's built-in commands rather than basic programming.  One of the problem for me with basic programming is that I do not retain the language when I am away from it for even brief periods.  

Steve -

Using the writein window is not a viable alternative for me - because I frequently want to actually work with the record, make changes etc.  "Bouncing" back and forth between the two is precisely what I want.

I am, therefore, trying to work with your "on element entry" code for the command button, which seem promising.

Since you say you may be doing something similar and just in case you copy/paste your code, I want to point out that there is a typo in line 4 where you say "nn = @selectreeitem"  It should read "nn = @selecttreeitem"  Again, I'm only pointing this out in case you decide to copy and paste.

Now, the code is not working; however, I have a feeling what might be causing the problem.  First, I do not know what "nn" means.  Coicidentally I have a labout element named "NN" (for nickname).  Something tells me that is creating the problem.

Can you further explain what the nn stands for .... or how to get around the conflict with the element name?

Also, I am a complete novice when it comes to "error checking", so if you could suggest language for that, it would be a big help.

I can conceptualize the programming (even if I don't fully understand it) so I think it will do the trick nicely, with a little tweaking (as you say).

Getting this flat will be greatly appreciated.  Thanks!

2 more thoughts:

If you are running in a Client/Server setup, perhaps you could open a second instance of Sesame and bounce between the two programs. (seems kind of sloppy to me)

Or

Create a copy of your form within the same database. Make a minor change to the form (maybe just change the color of the form) and then you can have both forms open at the same time. Bouncing between the two by simply clicking on the tabs at the bottom of the page. (Similar to how you can have Add Data mode AND Search/Update Mode open at one time) This will then allow you to copy and paste between the two or use programming to 'post' data from one form to another using the Formfieldvalue() command.

Steve

Nice!

Isn't this fun?



Steve