I needing a continuous form (fLocation, based off tLocation) which users add records directly on.
Fields are:
Where there are FKs, I need to display meaningful text, rather than the IDs, hence the initial idea to use combo boxes, for example:
cboFIDUsage
Control source: tLocation.FIDUsage
Row source: SELECT tUsage.IDUsage, tUsage.UsageAbb AS Abb, tUsage.Description FROM tUsage
Bound Column: 1
Column Count: 3
Column Width: 0,2,6
However, the cbobox arrows will take up too much space (about 6cm), so I thought I could have a textbox, i.e txtFIDUsage that is displayed on top of the cboFIDUsage until the focus is on it at which point: On Got Focus switches to the cboFIDUsage:
However, that txtFIDUsage could only display FIDUsage (which is an ID#) obviously not the text which is pointless. Is there anyway to display in txtFIDUsage the text that the cbo displays? I understand you can't hide the arrow on a cbobox, but I wouldn't want to for data entry/modification purposes anyway.
Or any other suggestions how to save space horizontally? I don't want to base this form off a (multi-table) query as I want to add records directly via the form.
Additionally the headers and footers will have stuff in, the header will have filters and the footer will have totals based on the filters results (each room has workstations in it, for example) plus buttons to run reports based on the filter results so a continuous form really is desirable. It's just the space saving horizontally.
Fields are:
- IDLocation
- FIDBuilding (FK, to tBuilding.IDBuilding) --- cboFIDBuilding / txtFIDBuilding
- Room
- FIDUsage (FK, to tUsage.IDUSage) --- cboFIDUsage / txtFIDUsage
- FIDFaculty (FK, to tFaculty.IDFaculty) --- cboFIDFaculty / txtFIDFaculty
- (etc... there are 6 more fields, 8 fields are links to other tables (cboboxes))
Where there are FKs, I need to display meaningful text, rather than the IDs, hence the initial idea to use combo boxes, for example:
cboFIDUsage
Control source: tLocation.FIDUsage
Row source: SELECT tUsage.IDUsage, tUsage.UsageAbb AS Abb, tUsage.Description FROM tUsage
Bound Column: 1
Column Count: 3
Column Width: 0,2,6
However, the cbobox arrows will take up too much space (about 6cm), so I thought I could have a textbox, i.e txtFIDUsage that is displayed on top of the cboFIDUsage until the focus is on it at which point: On Got Focus switches to the cboFIDUsage:
Code:
Private Sub FIDUsage_[B]GotFocus[/B]()
Me.cboFIDUsage.SetFocus
End SubOr any other suggestions how to save space horizontally? I don't want to base this form off a (multi-table) query as I want to add records directly via the form.
Additionally the headers and footers will have stuff in, the header will have filters and the footer will have totals based on the filters results (each room has workstations in it, for example) plus buttons to run reports based on the filter results so a continuous form really is desirable. It's just the space saving horizontally.
