Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Box

Status
Not open for further replies.
conwil

conwil

Programmer
Sep 5, 2001
3
US
I am trying to populate a combo box in a subform with the previous rows selection. Can anyone help.
Thanks,
conwil
 
Sort by date Sort by votes
Can you give any more detail about this? I'm not sure what you want to do.

Bob
 
Upvote 0 Downvote
I have a subform that will be used to input data. Some of the date will be duplicated on the next line and i want to have that data show on the next line automaticly(ex: year(1998) and state(IN). Hope this helps.
 
Upvote 0 Downvote
Perhaps something like this...

In the On Enter event of combo box write

ComboBox = Dlast("FieldName","TableName")

This will insert the data from the last record, when combobox in a new record receives focus. (If this is what you need).

Mangro
 
Upvote 0 Downvote
Mangro,
Thanks that worked. Just what I needed.
ConWil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
353
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
290
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
1K
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question
Make second combo box display records dependant on selection from first combo box 1
Replies
2
Views
241
dhookom
dhookom
JayRo71
  • Locked
  • Question
Select records on subform using a combo box with a twist 1
2 3
Replies
56
Views
1K
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top