Form Help - A Tricky Project (Combo Box, Commands, ID Numbers)

[Amoredelmar]

Okay for some reason, I can not get these items to work as one. Here are my intention.

Refer to attached for Reference
1. Where #Name? shows, I am attempting to get the following information to be visible.
A. If "Business" is Null show "First Name, Last Name".
B. If "Business" is not null show "Business Name" only.

2. Command Lines "New" "Save" "Close" (deleted accidentally but I will put it back.
A. On any record changed or edited a pop up allowing the user to "Accept Changes" or "Discard Changes" For that matter on any navigation from the form.



3. On "New" and "Save and New" Command, action to generate a Client ID Number. This number would be a text/number/date combination.
Example of what I attempted
DT 03-30-2010-001
DT is a constant
03-30-2010 is the current date
001 is the next number for that current date

4. Combo Box
A. Should show list of Clients from Client Table (easy enough)
B. If I type "Sein"
List should filter "Seinfield" "Seingold" etc...
C. On selection of filtered results or complete drop-down results the fields would populate with the data from that client from the table.


I seem to be able to do most of this stuff individually but putting it together seems to be impossible for my skill level. For everyone smarter than me, if you can help I would appreciate it.

[Amoredelmar]

Guess its not possible, thanks for the help anyways.