I've created a database by looking at an existing one that was built by a friend of mine. It works ok...but when the records are viewed in a form to update information, they are not in alphabetical order (which I would like them to be).
Here is what I have:
tblParticipant
PartID (Autonumber)
PlanName (Combobox on form)
Participant Name (Text)
PaperWorkMailedTo (Combobox on form)
AccountBalance (Number)
TypeOfDist (Combobox on form)
TotalDist (Y/N)
CashOutProvision (Combobox on form)
DistCompleted (Date)
I also have a table for each combobox.
Everything works fine when information is being entered for the 1st time, but if you want to edit or update anything by viewing the information in the table, I can't find a way to sort it. I posted a message in the Forms Forum yesterday and the response I got was that the form needed to look up data from a query. So what I did was create a query and then changed the form to pull info from the query. The problem I have now is that no data can be entered into the from.
This seems to be a little over my head. Any explination or help would be appreciated!
-Chad