field updates in relation to a table

[LUNG4114]

hello all!,
This will be my first post. In any case, here is my dilema. I have created a database to track entries based on ticket, kinda like northwinds but not. im using access 07. what i have done was create a table with all relevant data neeed, another table with employees and a third with supervisor.
the main form used for data entry auto populates the employee name and supervisor. but when the form is submitted, the table housing the data does not pupulate the name of the employee and supervisor selected. not sure what is wrong but i would love to get this fixed.
thanks in advance to all who may be able to help.

 

[CyberLynx]

If the Form fields (Text Boxes or Combo Boxes) are bound to Table then something must be going there if there is indeed a name displayed in the initial Form itself. It may not be what you expect but there should have been something placed into table. Perhaps a number instead the Name text?

What is populating these Form Fields when the Form is opened?

Are these Form Fields actually Text Boxes or are they Combo Boxes?

If you are selecting the Employees name and the Supervisors name through Combo Boxes then chances are you have the wrong Combo Column bound to to the control. Check the Bound Column property of the Combo Box.

.

 

[LUNG4114]

If the Form fields (Text Boxes or Combo Boxes) are bound to Table then something must be going there if there is indeed a name displayed in the initial Form itself. It may not be what you expect but there should have been something placed into table. Perhaps a number instead the Name text?

What is populating these Form Fields when the Form is opened?

Are these Form Fields actually Text Boxes or are they Combo Boxes?

If you are selecting the Employees name and the Supervisors name through Combo Boxes then chances are you have the wrong Combo Column bound to to the control. Check the Bound Column property of the Combo Box.

.

The forms open are being populated by an initial loginform that stay open on the side, the user selects their name and supervisor, and upon opening the order entry for their name and sup populate in the designated fiels. however as with be fore the table does not update with thos fields entered. does that make sense?
the form field for the employee name is controlled by.
=[Forms]![EmployeeF]![List3]

the field update for super visor is the same except its [List4]

and as i said before, the form is updating with the names, but the table itself doesnt.

 

[CyberLynx]

Uhhh...I think I see what is going on here.

From what I've read thus far, your Form is obviously bound to a table. You need to ensure the the Control Source property for the Employee Name is set to the Employee Name field in Table. The Same applies for the Supervisor but the Control Source property must contain the Table field name for the Supervisor.

Now in the Default property for the Employee Text Box on Form enter:

[Forms]![EmployeeF]![List3]

and in the Default property for the Supervisor Text Box on Form enter:

[Forms]![EmployeeF]![List4]

.

 

[LUNG4114]

thank you so very much for that. i cant believe i didnt think about that. now i guess my final question is, how do i make a start up screen appear like the northwinds demo, that then leads to the login screen?

 

[CyberLynx]

Well....in reality, the easiest way is to simply copy it. With your current Database project Open, also open the Northwind.mdb database file while holding the Shift Key down. In the Form section of the Northwind Database Objects Window select the Startup Form then from menu select Edit | Copy.

Now set focus back onto your own project, select he Forms Section of the Database window then from the Menu select Edit | Paste. Name the Form whatever you like.

To view the Functions used within the Form and Form Controls properties of the Northwind.mdb Startup Form, see the Database code Module conveniently named....Startup. This module can be located within the Modules section of the Northwind Database Objects Window.

Open the Copied Form in your own project and modify it any way you like.

To have it automatically start when the Database is fired then place that Form name into the Display Form/Page property of the Startup options dialog (menu Tools | Startup).

.

 

[LUNG4114]

thank you very much, its always the simple small things i seem to look over. the sheet is running well. the final step is to create an action that utilizez the login screen so it doesnt have to stay open. and still pull the proper information. but i assume that takes a few more queries and all.. but again thank you very much.