I'm still having trouble with this. I don't know what I'm doing wrong. I followed code but still getting errors. I think it may be how I created tables. I have 3 tables.
Culture Table
CultID
VenueID
LocID
StartDate
EndDate
Event
Venue Table
VenueID
Venue
Location Table
LocID
VenueID
Location...
When I typed in what you gave me for the Venue Combo Box I get an Compile error and it highlights the word select.
***
Private Sub Venue_AfterUpdate()
CulCalTesting.Location.rowsource=select LocID,VenueID,Location,Phone,Website where VenueID="&CulCalTesting.Venue & ";"
***...
Hi,
I had a question on updating combo boxes and several text boxes all based on what the user picks for the first combo box but data is from two different tables. I tried the example in the FAQ question but didn't know how to put if different tables.
Venue Table
VenueID
Venue
Location Table...
The Query is updatable. All the properties for the AllowEdits, AllowDeletions, and AllowAdditions are set to yes. I don't understand. I've even tried to use the tables in the form instead of the Query. Once I put in also same problem. I'm really stumped. I asked a friend of mine to take a look...
I'm having a bit of trouble with an access project I'm working on and hope someone could help.
I have multiple tables all with one to many relationships. I've created a query and was trying to make a form. When I create the form from the query it doesn't let me update, add or do anything...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.