Tab clears form fields after i choose date picker

[Reidy]

Hi,



I'm a complete Access noob so please be patient. My issue is this

Basically i've created a very simple set of3 tables customer, order, part code and have what I think is working relationships.

I created a form so I can enter a new customer name and it has its own unique ref and I can add part codes and an order date.

Ive set the tab order but there are two issues.

1. The date picker auto goes to 01/01/1900
2. I can change the date picker but then when I tab past it it wipes all the other fields

[aytee111]

Not sure I understand your issues. Can you post your database?

[Reidy]

Hi, yes how do I do that. I cant attach it as it is over the size limit?

[aytee111]

Do a compact and repair, then zip it. Remove some data if it is still over the size limit, we only need a sample.

[Reidy]

See attached database

Open the form and you will see firstly the calender always default to the year 1900, secondly when you change the date ad tab on to the next field it wipes the other fields and then you cant save it or close it without an error as its lost its data

[aytee111]

I have given you a basic new form, along with new tables, on how to begin entering orders. The reason I created new tables was purely to show you the naming conventions which are generally used, such as removal of spaces. This should give you a place to start.

[Reidy]

Hi,

That's great. So a couple of things. Can you tell me where I went wrong?

Why did the calender always start at the year 1900
I see very little difference in what we both did, what did you do differently?
On the order form I want to be able to add a new customer as well as picking from the existing list but that field seems locked to the customers entered in the customer table

[aytee111]

I don't know why the date was at 1900, when I went to add a new record it worked as it should. I couldn't work out the tab thing either. Best in these cases to start afresh.

To add a new customer, you can run an append query in the NotInList event which appends a record to the customer table.

[ssanfu]

<snip> Can you tell me where I went wrong?

Why did the calender always start at the year 1900<snip>

Well, since you asked...... (this is to help you)

Basically, your design is wrong.

How/why would the customer ID (an autonumber -type Long Integer) be connected to table "Part Codes" on "Part Code" (a text field) ??


Your form has a record source of

The customer ID (an autonumber) is linked to "Order Date" (a Date/Time)??
So Access defaults to the earliest date.... 1/3/1900.

Linking fields (PK/FK) should (must) be the SAME type...


I would suggest you step back and work through these 3 tutorials before going any further. Actually take the time to do the tutorials, not just watch them.


Good luck with your project.........