Hello everyone,
I'm new to Access so my apologies if I have missed something basic, but I can't seem to get my head around this issue.
I am trying to use a query as a Row Source for a combo box to provide the user with a list of choices. I'd like the choices to be the values stored in four different fields from a single record.
How do I use a query to return the values from multiple fields but from the same record so I can use it as a list of choices in a combo box?
If anyone can point me in the right direction or show me an alternate solution that would be much appreciated! Thanks everyone!