Re: Automatic Form Completion

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"NetworkTrade" <NetworkTrade@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54967B9D-ADAD-424D-8D2B-A89A918C2CFB@xxxxxxxxxxxxxxxx
I do not disagree with Rick's advice.....but only comment is that when one
creates a combobox, assuming you have the Wizards turned on, then it is going
to prompt you as to whether you want the combobox selection to be used to
select a record...

if you select yes...then this is done for you.

not sure what version of Access you are using.....consider deleting your
combobox and re-adding and seeing if the wizard gives you this prompt.....

But that is for a completely different purpose. If the form is bound to a table
of parts then a ComboBox like you describe would be a tool to navigate to a
particular part record.

If the form is bound to a related table and I am using the ComboBox to enter a
part number as a foreign key value then I do not want the behavior that the
"select a record" wizard option provides.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: finding data
    ... My question is how do I set up this database so when you open iti you ... In form design view make sure the Toolbox wizard is enabled (magic wand ... This will be the third choice in the first page of the ComboBox ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Q: Very strange error in combo-box wizard
    ... set the needed properties for the combobox yourself ... ControlSource --> EmpID ... RowSource --> SELECT EmpID, ... I'm trying to use the combo box wizard to find a record based on the selected value of the drop down. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Q: Very strange error in combo-box wizard
    ... the combobox yourself ... ControlSource --> EmpID ... If you want to modify the RowSource, ... I'm trying to use the combo box wizard to find a ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form wont allow add new record from combo box
    ... field (HospitalId) linked to table tblHospital. ... However I want to navigate by means of using a combo box on the main ... This is purely a wizard created form, ... A ComboBox is typically used to enter data OR to navigate. ...
    (microsoft.public.access.forms)
  • Re: How open and search a part number in a table in VBA
    ... Simplest method is to include a ComboBox on your Form, ... prompts in the Combo Box wizard that allow you to generate exactly what you ... Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)