How to add two fields to a single combobox and how to modify the close form button

[Hulas]

Guys, I have two questions.

(a) How do I add two fields of the same table to a single combo box. For example if I have two fields ID1 and ID2 in a table called Identification, than how should I design a combobox in a form such that when I scroll down I get to see both the ID's.

(b) I have a (Close Form) button on a form. Let's say I am adding a new record from a form and I am half way filling up everything and suddenly if I change my mind not to save the record than I have a button to close it, but the problem is if I hit the close form button it still saves the record. How do I make the button into where it will just close but not save the record.

Any help appreciated.

[missinglinq]

Question A

1. Place combobox on form
2. Select I want combobox to look up values in a table or query.
3. Follow prompts
4. Select Identification table
5. Select fields ID1 and ID2
6. Follow prompts to finish combobox

Question B

Place button on form, naming it DumpNewRecordAndCloseButton
Place this code behind it:

Private Sub DumpNewRecordAndCloseButton_Click()
 If Me.NewRecord Then
   Me.Undo
   DoCmd.Close acForm, Me.Name
 End If
 End Sub

Welcome to bytes!

Linq ;0)>

[NeoPa]

Please keep separate questions in their own threads in future.

This makes it easier to manage and to find later.

Admin.