Open form to particular record

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

From: Carl (carln_at_dfs.za.net)
Date: 05/07/04 

Date: Fri, 7 May 2004 11:30:15 -0700

This sounds very similar to using the Control Wizard to
add an unbound ComboBox to the header of the form, which
is then instructed to look up the record you want. The
problem I find with this, is that on opening the form,
the cursor goes to the body of the form (i.e. the default
record), so that one has to click onto the ComboBox
before entering the record to look up. Then after looking
up the record, the cursor stays in the lookup ComboBox. I
would like it to then go to the record looked up so as to
be able to edit it. Can anyone tell me what to do to
achieve these two objectives?

Carl
>-----Original Message-----
>Many time I will place a combo box in the Header of my
>form and have this combo box display the values I want
to
>use for the lookup. The on the AfterUpdate event of the
>combo box, I place code that will go to the desired
>record. Take a look at GoToRecord in the help file.
>
>HTH
>
>Byron
>
>>-----Original Message-----
>>I have a table containing several fields but the data
is
>>entered at different times. How can I set up my form so
>>that On Open it prompts for the RecordName and opens to
>>that record in the form. I tried the button wizard but
>it
>>doesn't always search on the right field and it's the
>find
>>and replace button dialog box that pops up. Thanks for
>any
>>pointers you can provide.
>>.
>>
>.
>

Relevant Pages

  • Re: Combobox displays data in drop down list, but after updated the box is empty ??
    ... combobox controls themselves are unbound, ... control to be "blank", unless you have a DefaultValue set for the control, ... records the excursion, first she opens the Customer Form, checks if the ... the second unbounded combobox is Customer, ...
    (microsoft.public.access.forms)
  • Re: Using another forms field value
    ... DoCmd.Close does give you options to specify the form to ... So when you close the results form, you can also close frmName, thus: ... combobox when the form is unhidden, if you'd rather do it that way. ... original form opens filtering the data on the combobox selection. ...
    (microsoft.public.access.forms)
  • RE: Combobox Question
    ... so when the form opens the Current event ... "Aria" wrote: ... first created the combobox and tested it to see if it was working, ... of seeing my name in the combobox since I'm towards the end of the alphabet. ...
    (microsoft.public.access.gettingstarted)
  • Re: Using another forms field value
    ... DoCmd.Close does give you options to specify the form to ... So when you close the results form, you can also close frmName, thus: ... combobox when the form is unhidden, if you'd rather do it that way. ... original form opens filtering the data on the combobox selection. ...
    (microsoft.public.access.forms)
  • Re: Multiple combo boxes on form to open another form
    ... ComboBox: Yes but I am not sure whether this is simpler than Calendar ... How do you propose to populate the ComboBox with date ranges? ... ComboBox has the Value Property (same as TextBox) and if you can ... the parameter box opens for each parameter before the input form is ...
    (microsoft.public.access.forms)