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

Jumat, 26 September 2014

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

Jorge

You won't see a way to enter a new item. However as soon as you type in a new item and move out of the combo box the form for adding a new item should automatically open.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <muralles_r12@yahoo.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.