brewer95
Last Activity: May 23 '07, 12:27 AM
Joined: Jan 20 '07
Location:
-
Thanks for the comments. I actually found the Orderby command and was able to have the date of the most recent entry appear first by placing orderby DESC in the VB code. -
Sorry about that....Leave a comment:
-
How to display most recent record?
I use a form to enter data into a table. The user then has the opportunity to recall the data in the form based on a search to review and update the info. For example, on my menu there is a combo box where the name is selected. Once the name is selected my code recalls the form with the previously entered data.
The problem I have now is that when the same name is used for a new trip (same person, new trip) my form displays the data... -
Thanks for the quick reply. When I place the combo box on the form, I only get two choices.
So here is what I was trying to do in code:
On the main menu, I have a combo box (cmbfindaircraf t) that is populated with aircraft names from a query table. I am trying to open the "frmaircraftArr ival Form" that displays data for that aircraft.
...Code:Private Sub cmbfindaircraft_AfterUpdate()
Leave a comment:
-
ComboBox to Open a Different Form/Record
I'm an access novice, so perhaps this is a no brainer....
I am trying to use a combo box on one form (called Menu) to pull a different form (called Aircraft Arrivals) based on the name of an aircraft (assigned as aircraft name in table). So, if I want to see the particular info on say RedPlane1, I select this from the combo box and the form & data, already entered, on RedPlane1 comes up. Any suggestions?
Than...
No activity results to display
Leave a comment: