BaldyWeb
A place for Access/SQL Server solutions
Form Solutions:
Open a second form to the record chosen on the first form
Open a second form to the record chosen on the first, but have all records available
The Selections in one Combo Box are Dependent on Another
Use a multiselect listbox to add records to a table
Make one control visible based on another
Use OpenArgs to pass values from one form to another
Stay on the same record after a requery
Autofill fields from another table
Query Solutions:
Get a value from the previous record
Get the information from the most recent record
Find records overlapping a given date range
Report Solutions:
Use a multiselect listbox to filter a report
VBA:
FAQ and Samples Section: