ACCESS FEED: Re: [MS_AccessPros] How use combo box to select a record to view

Jumat, 26 September 2014

Re: [MS_AccessPros] How use combo box to select a record to view

Jorge
You will have to click add new record in the navigation buttons below the form to add a new record.

Alternative 1:
Set form properties Dataentry to true. This will ensure that form takes you to a new record every time it is opened.

Alternative 2:
In the onload property use docmd.gotorecord,, acnewrecord.

Rajiv

On 26 Sep 2014 23:13, "muralles_r12@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Great, this is awesome, it work just well.

Thank you.

I am wondering if you could help me with another question.

I have combo box I am using to set up the ID value in one of my tables.

I want to be able to add a new item if the item is not in the list.

I set the allow value list edits to yes

Then I enter the name of the form to edit the list.

I go back to the form where I am displaying the combo box and I do not see the option to enter a new item to the list.

What am I doing wrong.

Thanks.

Jorge Muralles

On Friday, September 26, 2014 10:02 AM, "Rajiv torajiv@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Simplest solution:
Enable control wizards.
Add a combo box to form header - a un bound combo box.
In the wizard select : I want to find a record based on my selection.
Add the data from vendor table.
Finish.
Voila!

Rajiv
PS of course there are more complicated methods to doing this!!

On Friday, September 26, 2014, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning everyone.

Thanks John for getting back to me about my form and sub form problem.

I looked in the book and realized what I was doing wrong.

I am up and working now.

I have the form displaying the vendor info

I have the sub form displaying the contacts for the vendor.

-----------------------------------------------------------------------------------------

I have seen this and I am trying it.

In the form, I want to use the vendorID to navigate to the next record and see the related info in the sub form.

1. I make the vendor ID into a combo box

2. I set the record source property to a query that returns the vendorID and vendor name.

3. Set the properties for bound Column width and so forth.

4. It all works, but it will not let me use the combo box to select the record I want to view.

I can use the navigation bar for the form to move to the next record, I can see the combo box change accordingly.

Can anyone help me?

Thanks.