seach combo box on a "view only" form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to create a combo box that searches for records on a form
that does not allow additions or edits? This form is just for project
managers to look at - I don't want them to be able to change anything - but
they need to be able to find a project quickly, rather than just scrolling
through hundreds of records.

Any suggestions?
 
In form design, change the form's recordset type to "Snapshot" and add your
combo box that searches for a record. Leave the form's allow edits, allow
additions, etc. as "Yes".
 
In my version of Access (2003) in form design, on the Data tab, there's a
property entry for Recordset Type. It defaults to Dynaset (to allow editing
of data), I just changed it to Snapshot. It shouldn't matter if your Record
Source is a query, table, sql statement or whatever.
 
Back
Top