B
BeeAwwb
Good morning all,
I have a quick question, which may or may not be easy. I don't think
it will take too much, but my knowledge of lookups is not so that I
can complete this one myself.
I have a form which links to my main table. All other forms are
displayed as subforms displaying those records related to what you are
currently looking at. So, if I am looking at company 'Default', and
push the "Meetings" button, a subform will display
(Forms!Frm_Main!Subform_Meetings.visible = true) showing all the
meetings scheduled.
I can then page through the records with the previous and next
buttons. However, I would like to add some context to this, by having
2 text boxes display the next date, and the previous date.
Example:
Let's say that 28/06/2004 is my current record, 25/06/2004 is
previous, and 02/07/2004 is next. The 3 boxes would show
[25/06/2004] [28/06/2004] [02/07/2004]
Does anybody know how I might base these text boxes?
Thanks for any help you can provide,
-Bob
I have a quick question, which may or may not be easy. I don't think
it will take too much, but my knowledge of lookups is not so that I
can complete this one myself.
I have a form which links to my main table. All other forms are
displayed as subforms displaying those records related to what you are
currently looking at. So, if I am looking at company 'Default', and
push the "Meetings" button, a subform will display
(Forms!Frm_Main!Subform_Meetings.visible = true) showing all the
meetings scheduled.
I can then page through the records with the previous and next
buttons. However, I would like to add some context to this, by having
2 text boxes display the next date, and the previous date.
Example:
Let's say that 28/06/2004 is my current record, 25/06/2004 is
previous, and 02/07/2004 is next. The 3 boxes would show
[25/06/2004] [28/06/2004] [02/07/2004]
Does anybody know how I might base these text boxes?
Thanks for any help you can provide,
-Bob