Re: Read only form, still want to be able to use cbosearch box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

try

DoCmd.OpenForm FormName:="frmOrders", WindowMode:=acDialog
Forms!frmOrders.RecordsetType = 2

"2" is the code for Snapshot (refer to Rick's post elsewhere in this
thread).

hth


"Brook" <Brook@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8BFF215-213E-4A05-9791-DA43C4907037@xxxxxxxxxxxxxxxx
> Thanks Rick,
>
> would I modify this section of code:
>
> DoCmd.OpenForm FormName:="frmOrders", DataMode:=acFormReadOnly ',
> WindowMode:=acDialog
>
> or do I need to modify each field within my form?
>
> Brook
>
> "Rick Brandt" wrote:
>
> > Brook wrote:
> > > Marshall,
> > >
> > > the problem I have having is that my lookup doens't work, it will
> > > show the records that I am trying to go to, but won't let me choose a
> > > record for the form to "goto"?
> >
> > You are apparently making the form read only by using AllowEdits =
False. That
> > will also make unbound controls like your ComboBox read only. Instead
you could
> > make the form read only by setting the RecordSourceType to Snapshot.
That will
> > not affect your ComboBox.
> >
> > --
> > I don't check the Email account attached
> > to this message. Send instead to...
> > RBrandt at Hunter dot com
> >
> >
> >


.

Relevant Pages

  • Re: Send Object Action
    ... >Is it possible to modify that list to only show certain types ie excel and ... > the output format, a popup box will appear asking what ... > list to only show certain types ie excel and access ...
    (microsoft.public.access.externaldata)
  • Re: Subform fields auto-filled based on Main form combo box value
    ... of items they can select by setting the RowSource property? ... code modify the RowSource property then Requery the combobox. ... which has a combo box selecting Department from tblDEPTS ...
    (microsoft.public.access.forms)
  • ComboBox-size
    ... I want to add a combobox to a dialog and modify the height in the ... is there a way to select another font in the resource editor ...
    (microsoft.public.vc.mfc)
  • Re: Lookup in an Input Form
    ... going back into the form to modify the data is starting ... I'd like to select one of those ReqIDs in my combo box and have ... If you turn the wizards on, ... ask what your combobox will do. ...
    (microsoft.public.access.formscoding)
  • Re: bluring a messy background?
    ... program so he can modify a snapshot. ... That has some selective blurring tools which should work. ... FocalPoint has a 30-day free trial: ...
    (rec.photo.digital)