Date not stored in table

[Pvarga]

I am VERY new to Access and need help. I recently made a database for our department. I have a form for employees to use to enter new clients. I have a field set that they enter a level number and that fills in another field depending onthe number they enter. When I am looking at the form it works and the other field changes correctly but when I look at my table there is nothing in the second field. Why is it showing onthe form but not filling in on my table?

Thanks much

Tricia

 

[juice75]

Based on the information you've given I'm assuming the 'Level Number' field and it's related field on your Customer entry form exist in another table besides the Customer table. In this case you most likely are autolooking up the related field from the [enter other table name here]. You may try to include this related field from the Customer table and use the DLookup function to place its value in your Customer table. Without more detail it's difficult to troubleshoot your issue. Hope this helps.
OJ

 

[RV]

>I have a field set that they enter a level number and that fills in another field depending onthe number they enter.<

Two questions:
1)How do you "fiil in" the other field?
2)On which recordsource is the other field
based?

RV

 

[Pvarga]

I will try to explain what I am doing.
There are 6 levels students enter at. Levels 1 - 4 are called by a certian program type name and 5 and6 another. We have an Iif statement in the program type box that states that if Level is 1 then the program type is Adult Basic Education, that is listed for 1 - 4 and then 5 and 6 are called
Adult Education. I will have to query each field seperately later for 7 different reports so I do need each of these but I was trying to make it easier for the person entering the date and make the one field automatically fill out. I do have 2 tables and one of them is just the 1 - 6 in the first col and the name in the 2nd but stopped using that because I was using it as a drop down until I saw that I could only store the date from one col. Someone suggested the IIf statement as an alternative. The source for each is just ist own name. Level for level and registration type for the othter.

I also would love a suggestion for me to learn more about this but there are so many books out. I have used the Shelly Cashman book for the first along with a CBT tutorial but have nothing to continue.

Thanks for all your help.

 

[Pvarga]

I am so sorry I keep type date instead of data. I hope it is not confusing anyone. This is not a date field.

 

[RV]

I can't help you on books.

For your form though, why don't you use a listbox showing the levelnumber and program type?
I assume you're storing the levelnumber for a new client in a "client" table.
Use a table containing ONLY the different levels. The program type can be derived from the levels.
Create a query to get the corresponding program types from the level numbers:

SELECT tblLevel.Level, IIF(tblLevel.Level IN (1,2,3,4),"Adult Basic Education","Adult Education") AS ProgramType
FROM tblLevel;

Base yor listbox on this query, when creating the listbox choose to store the levelnumber in the corresponding column in your "clients" table.

Suc6,

RV

 

[David R]

If the two fields are as intimately related as you make them sound (one determines the other, absolutely), there is no need to store them both in your main table. You can use a query and connect this table to the 'lookup' table anytime you need to see the "connected" value. This is one of the advantages of relational databases: You can store [57], instead of [ACE Hardware],[345 Main St.],[(901) 555-1234],[John Smith],[Manager],[Hardware Supply Store], in every record.

HTH,
David R