Share via

Auto populate a cell in Access

Anonymous
2025-04-23T12:29:03+00:00

I am a complete novice at Access, and I am trying to create a program that when a user enters in a airport city code it will automatically populate the city into a different box. I know in Excel I can use XLOOKUP, but I am not sure how to get the data to auto populate after they select an item from a combo box. Is there an equivalent XLOOKUP for Access? Any guidance would be appreciated. I am afraid it is going to require a script of which I have no idea. Here is a link to the file. For some reason I wasn't able to put screen shots in here. Travel Planner1.accdb

Microsoft 365 and Office | Access | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-04-25T16:49:09+00:00

    PS: I should have mentioned in my last reply that, if the AirportCode foreign key column in the referencing table allows Nulls, i.e. its Required property is False (No), then, if you base a form on a query which joins the two tables, as described in the final paragraph, the join should be a LEFT OUTER JOIN. The default join type of INNER JOIN requires there to be a match in each table for a row to be returned, whereas a LEFT OUTER JOIN returns rows from the referencing table regardless of whether there is a match in the referenced table or not.

    0 comments