My experience predisposes me to give a lot of credibility to MVPs even when I am initially skeptical of something they say.However, given the full context of their complete argument. First, a quick primer on this handy feature of MS Access for anyone that is not familiar with it.In the design view for a table definition, you can define a display control type for a each field that is used to display it in data-sheet view and also used as a default when the field is added to a form.“Lookup field” in this context of this article and the one it responds to simply refers to a field defined with a “Combo Box” display control that uses a table or query as the row source. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. Order Status = Inactive " & " WHERE [Order Name] = '" & Order Name. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I am trying to create an 'Update Query' in vba but I am missing something. I have a drop down combo box with four columns set and bound to column 1. Column(1) & "' AND [Primary Work Group] = '" & Order Name. Thank you, Tony Try this: Dim s SQL As String s SQL = "UPDATE Orders SET Orders.
If so, then all you need is this in combobox's After Update event: Me.
A comment on one of my answers on Stack Overflow brought to my attention a blog article “The Evils of Lookup Fields in Tables” that argues against defining lookup fields in MS Access table definitions. I don’t do nearly as much Access development as I once did, but I had never encountered any serious issues using Lookup fields.
The article is written by Arvin Meyer and Joan Wild, who appear to be part of the Microsoft MVP program.
Make it easy to do the job and the user is less likely to make a mistake and enter something they didn't mean.
In short, the database designer's job is to make their database usable.
One way to help prevent bad data is to make the job of entering data as easy as possible for the user.