I have a scheduling program that I am working on. Some time ago, I bought a data, “GRID”, module that someone had developed as part of a motel registration application. Its purpose is to display a range of “from-to-dates” for reservations. However, the company doesn’t seem to be in business any longer. The difficulty that I am having is in trying to get information to change/refresh in a display label for the names of new entries. The display label works just fine for existing entries that came with the data module; it’s just when I try to add new entries that I the display will not work/refresh.
The following is a description of how everything is supposed to work for the attachment that I am including. In appreciation, and in exchange, keep the attachment of the file for your personal use. PRINT OUT THIS POSTING TO GO WITH THE ATTACHMENT. In the meantime, I’ll monitor this posting for your comment and any questions that you might have.
MOST grateful,
John
I have three forms; two with tables and one (unbound) display form:
1. Form: frmGuest (label name: fsubGuest)
Table: tblGuest
GuestID (label name: cboGuestID)
Form is used to create individual records for future registrations and list
past Registrations.
2. Form: frmStatus
Table: tblstatus
Form is used to create registration schedules for individuals pulled from the form, “frmGuest” and table, “tblGuest”.
This form contains a command button, called, “cmdGridSync” with the label, “See on Grid” located on the form, “frmMain”.
You normally would select a name from the combo box, “GuestID”, (label name: cboGuestID) on this, “frmStatus”, form along with the appropriate scheduled date. You would then press the command button, “cmdGridSync” with the blue triangle image. When pressed you are immediately taken to the scheduling Grid.
Whatever name you had selected before pressing the command button, above, will now appear in the, label control, “lblCurrStat” on the, “frmMain form below along with the corresponding date in the Grid.
3. Form: frmMain
Table: NA
Form is used to display registrations, made from the form “frmStatus”, in a GRID.
The form, “frmMain” contains the label control, “lblCurrStat” that displays the name of an individual selected in the, “frmStatus” form. You can also use the unbound combobox labeled, “cboFilterGuest” on this form to select other names without going back to the frmStatus form.
My Problem:
All the above will work, except only with existing registrations, but not new ones. When you add the name of a new individual in the, form, “frmGuest” and table, “tblGuest” described above, it will not display that person’s name in the label control, “lblCurrStat” located on the, “frmMain” form, However, the date range, i.e., from-to does show up in the GRID.
John
The following is a description of how everything is supposed to work for the attachment that I am including. In appreciation, and in exchange, keep the attachment of the file for your personal use. PRINT OUT THIS POSTING TO GO WITH THE ATTACHMENT. In the meantime, I’ll monitor this posting for your comment and any questions that you might have.
MOST grateful,
John
I have three forms; two with tables and one (unbound) display form:
1. Form: frmGuest (label name: fsubGuest)
Table: tblGuest
GuestID (label name: cboGuestID)
Form is used to create individual records for future registrations and list
past Registrations.
2. Form: frmStatus
Table: tblstatus
Form is used to create registration schedules for individuals pulled from the form, “frmGuest” and table, “tblGuest”.
This form contains a command button, called, “cmdGridSync” with the label, “See on Grid” located on the form, “frmMain”.
You normally would select a name from the combo box, “GuestID”, (label name: cboGuestID) on this, “frmStatus”, form along with the appropriate scheduled date. You would then press the command button, “cmdGridSync” with the blue triangle image. When pressed you are immediately taken to the scheduling Grid.
Whatever name you had selected before pressing the command button, above, will now appear in the, label control, “lblCurrStat” on the, “frmMain form below along with the corresponding date in the Grid.
3. Form: frmMain
Table: NA
Form is used to display registrations, made from the form “frmStatus”, in a GRID.
The form, “frmMain” contains the label control, “lblCurrStat” that displays the name of an individual selected in the, “frmStatus” form. You can also use the unbound combobox labeled, “cboFilterGuest” on this form to select other names without going back to the frmStatus form.
My Problem:
All the above will work, except only with existing registrations, but not new ones. When you add the name of a new individual in the, form, “frmGuest” and table, “tblGuest” described above, it will not display that person’s name in the label control, “lblCurrStat” located on the, “frmMain” form, However, the date range, i.e., from-to does show up in the GRID.
John
