subform update

[helpaccess]

created a new data base. Need to bring in data from old data base. not showing up in the form. All data is in the table and query and subform query. Not in the data form itself.

 

[Scooterbug]

A bit more information would be helpful. Is the form bound to the queries? What happens when you run just the queries?

 

[helpaccess]

Yes, it is bound to the query. The date is all in the query. But when I open the subform and bring up a person the dat is not there.

 

[Scooterbug]

is the subform linked correctly to the main form? I am assuming that your main form contains data on a person. The subform contains details about that person?

 

[helpaccess]

Yes, I even redid the subform. THe subform is where I am entering in the data for a person.

 

[Scooterbug]

Can you post the db? You can remove any sensitive data if you want (Or leave some dummy data). if using A2007, save it as a mdb file. Also, you can compact and repair as well as zip the file up if the size is too big.

 

[pbaldy]

Make sure the Data Entry property of the subform isn't Yes.

 

[helpaccess]

the data entry is no. All the rest are yes

 

[pbaldy]

Scooter appears to be offline, but you never addressed the question about links. I suspect the suggested sample is the easiest way for anyone to help at this point.

 

[helpaccess]

This the date in the Query(sample not all)


ID 799881
Name
Year 2009
Code 019
subcode A


When I pull up my form and look up the ID there is no data.

 

[Scooterbug]

It would REALLY help if you posted at least the db with the tables, forms and queries that you are having problems with.

 

[helpaccess]

View attachment combind travel team.zip Here it is. The table and queries are (Table) traveling expense tracking (Query) detail expense tracking and form:expense tracking

 

[Scooterbug]

I dont have A2007, so I cant open it up. Can you save it as an MDB file?

 

[helpaccess]

When I save it you only see the tables. how do I get the rest.

 

[helpaccess]

View attachment combind travel team1.zip

There you go. thanks for you help this far.

 

[Scooterbug]

It's your Child/Parent Link fields. When you link a subform to a form, you can only link 1 field. This is what you have:

Link Parent Field: Full Name;Employee ID;Curr Hourly Rate - Actual
Link Child Field: Full Name;Employee ID;Hourly Rate

Pick one. I would assume that it should be Employee ID (And you shouldn't use spaces...can cause problems later on.)

I cannot test it because the table that houses the Employee Data is from a linked table, so the form wont open for me.

 

[helpaccess]

ok I will try that and let you know. maybe you can help me with something else. I would like to have a lookup for the code subcode and only see them once also have the location be there to.

 

[Scooterbug]

ok I will try that and let you know. maybe you can help me with something else. I would like to have a lookup for the code subcode and only see them once also have the location be there to.

Yes, that is possible. First though, I would clean up your tables. You use some reserved words (Code for one). Also, I would take out any spaces in the field/table/query/form names. They will cause heartache later on. Second, none of your tables have primary keys assigned to them. Not good. Each table should have a primary key...that is what keep each record unique. Also, when you need to store a foreign key (EmployeeID in the TBL_Incentive pay Detail for example) you should be storing it as a long integer. You will wind up with data type mismatches if one is a number and the other is text when you try and setup a relationship between them.

To do what you want, change the text box for the Code to a combo box. You can add the Subcode and location to that row source and reference them by using the .column(x) property.

 

[helpaccess]

What table do I need to be in to change the code from a text box to a combo box and where is the column(x) property located?

 

[Scooterbug]

You dont change the table, you change the form. To reference the column, it would be this:

Me.ComboBoxName.Column(x)

Remember that when dealing with combo boxes, columns start at 0.