Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-13-2018, 07:44 PM   #16
MS ACCESS PROBZZZ
Newly Registered User
 
Join Date: Jun 2018
Posts: 15
Thanks: 11
Thanked 0 Times in 0 Posts
MS ACCESS PROBZZZ is on a distinguished road
Re: VBA not requerying form on not in list event

@moke123 Thanks for the link on the Option Explicit. I'll study up on that.

But I think we might be talking about the same thing when it comes to lookup fields.

Here's how my sql looks in one of my row sources for Tbl_BaseSku:

SELECT Tbl_ProductCategory.[ProdcutCategory_ID], [Tbl_ProductCategory].[ProductCatCode], [Tbl_ProductCategory].[ProductCategory] FROM Tbl_ProductCategory ORDER BY [ProdcutCategory_ID], [ProductCatCode], [ProductCategory];

If there's a different way to do this and get the same data with the same relationships then I don't know about it. If you were thinking I was using the Access Lookup Wizard and entering my list options directly into the table (I just call this embedding for lack of a better word), then no I'm not doing that.

And the attachments are images that I need to see in the interface, record by record.

MS ACCESS PROBZZZ is offline   Reply With Quote
Old 06-13-2018, 08:44 PM   #17
moke123
Me.Dirty=True
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 602
Thanks: 0
Thanked 190 Times in 179 Posts
moke123 is on a distinguished road
Re: VBA not requerying form on not in list event

this is what I mean by a table level lookup field

Attached Images
File Type: png LUField.PNG (40.2 KB, 51 views)
moke123 is offline   Reply With Quote
Old 06-13-2018, 09:46 PM   #18
MS ACCESS PROBZZZ
Newly Registered User
 
Join Date: Jun 2018
Posts: 15
Thanks: 11
Thanked 0 Times in 0 Posts
MS ACCESS PROBZZZ is on a distinguished road
Re: VBA not requerying form on not in list event

Wait, that's what you mean by table level look up field? I thought that was the way you were supposed to do it. How else can this be done?

MS ACCESS PROBZZZ is offline   Reply With Quote
Old 06-14-2018, 02:11 AM   #19
moke123
Me.Dirty=True
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 602
Thanks: 0
Thanked 190 Times in 179 Posts
moke123 is on a distinguished road
Re: VBA not requerying form on not in list event

In the table set your display control back to textbox.
On your form bind the combobox to the appropriate field and then set your rowsource in the combobox properties.
moke123 is offline   Reply With Quote
The Following User Says Thank You to moke123 For This Useful Post:
MS ACCESS PROBZZZ (06-14-2018)
Old 06-14-2018, 03:35 AM   #20
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,136
Thanks: 54
Thanked 1,968 Times in 1,881 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: VBA not requerying form on not in list event

Had you post the db earlier, we might solved it the soonest.
Attached Files
File Type: zip ProdCategory.zip (77.0 KB, 3 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
MS ACCESS PROBZZZ (06-14-2018)
Old 06-14-2018, 12:14 PM   #21
MS ACCESS PROBZZZ
Newly Registered User
 
Join Date: Jun 2018
Posts: 15
Thanks: 11
Thanked 0 Times in 0 Posts
MS ACCESS PROBZZZ is on a distinguished road
Re: VBA not requerying form on not in list event

@arnelgp you are a genius! A true god of VBA. THANK YOU!

I have to study how this works but it works!!!

MS ACCESS PROBZZZ is offline   Reply With Quote
Reply

Tags
on not in list , refresh a list , refresh requery form , requery a combo box , vba access 2016

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Not In List event to include edit form Wysy Forms 9 12-30-2016 02:50 PM
Requerying a list box based on a query problem JamesWB Queries 1 10-03-2014 11:11 PM
requerying combobox after NotInList event Sketchin Forms 5 09-10-2014 01:14 PM
Requerying a list box LOUISBUHAGIAR54 Forms 7 05-20-2012 07:24 AM
Requerying a list box based on a combo box selection Dannyboy11 Queries 4 07-12-2010 01:25 PM




All times are GMT -8. The time now is 08:45 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World