Form View is Blank after making a change

[czechmate55]

Newbie here! I have been working on an existing form for about a week. This morning, I added a text box. I needed to add the information into the list box, so I went into the query and added the table and information. Under properties, I was then able to add the data in the Control Source. When I went back to the form View, the entire detail section is blank. I'm wondering if I accidentally clicked on something or added the information wrong in the query. I did notice when I went into the query builder, nothing was selected in the field, table, etc sections. Since I added the other table, I then selected everything I needed so they would all show up on the list box. Can you please tell me what I did wrong? Thank you!

 

[dhookom]

Why do you think you need to change your form's record source rather than just the Row Source of the list box?

Typically, if you see only a blank form, the form's record source is not updateable and the form is set to Data Entry.

If you can't figure this out, you should reply back with other significant information such as the Record Source of the form and Row Source of the list box. There may be other information that is significant.

Duane
Hook'D on Access
MS Access MVP

 

[czechmate55]

I guess my understanding is the row source is for a combo box or list box. I am trying to bind a text box so the user can add data into that box. The only way I know how to add the field I need into the list box is to go into the record source and add the table I need.
Thanks!

 

[dhookom]

Yes a Row Source is a property of a combo or list box. I just don't understand at all what you are attempting to accomplish and why? You didn't respond to my question about the record source/row source.

I was expecting some information about the tables involved as well as their primary/foreign key relatsionship.

I also mentioned "form is set to Data Entry" which you have not confirmed or denied.

Duane
Hook'D on Access
MS Access MVP

 

[czechmate55]

Sorry for my confusion. I have a form for a user to fill out..First Name, Last Name, Address, etc as well as drop down boxes to select Data (segment, Sector, Scale). All information for this is on one table called GeoData. The form was working fine until I tried to add another text box for the user to add data called Attributes. I created a query using an Inner join of the two tables. The primary key is the GeoDataID with a foreign key in the Attribute table.

Also, Allow Edits is set to Yes, Allow Additions is set to No and Data Entry is set to No.

I also noticed when in the query, I changed it to dataset view, none of the data is there and it will not let me update.
Again, thank you!

 

[dhookom]

Can you provide the SQL view of the form's record source?
If you aren't seeing any records in the Record Source datasheet then your relationships/joins are probably wrong. You may need to use a join that displays all of the information from GeoData.

I would expect the attribute table to have a primary key that relates to a field in the GeoData table.

Again, please describe your tables with their relationship and significant fields.

Duane
Hook'D on Access
MS Access MVP

 

[czechmate55]

Here is the SQL

SELECT GeoDataSet.GeoDataSetID, GeoDataSet.GeoDataSetName, GeoDataSet.SourceID, GeoDataSet.GeoDataSetDescTitle, GeoDataSet.Purpose, GeoDataSet.Abstract, GeoDataSet.Notes, GeoDataSet.ProjectionID, GeoDataSet.DHS_SectorID, GeoDataSet.DHS_SubSectorID, GeoDataSet.DHS_SegmentID, GeoDataSet.LastUpdate, GeoDataSet.Scale, Attribute.AttributeName, Attribute.Description
FROM GeoDataSet INNER JOIN Attribute ON GeoDataSet.GeoDataSetID = Attribute.GeoDataSetID
GROUP BY GeoDataSet.GeoDataSetID, GeoDataSet.GeoDataSetName, GeoDataSet.SourceID, GeoDataSet.GeoDataSetDescTitle, GeoDataSet.Purpose, GeoDataSet.Abstract, GeoDataSet.Notes, GeoDataSet.ProjectionID, GeoDataSet.DHS_SectorID, GeoDataSet.DHS_SubSectorID, GeoDataSet.DHS_SegmentID, GeoDataSet.LastUpdate, GeoDataSet.Scale, Attribute.AttributeName, Attribute.Description;

 

[dhookom]

You have a totals query which is never updateable. You would have to get rid of the GROUP BY.

Also, one or both of these should be a primary key GeoDataSet.GeoDataSetID or Attribute.GeoDataSetID.

Can you provide the relationship information I asked for? Is this a one to many relationship and if so, which table has the many and which the one?

Duane
Hook'D on Access
MS Access MVP

 

[czechmate55]

Ok, I see the group by.
The GeoDataSet.GeoDataSetID is the primary key and the Attribute.GeoDataSetID is the foreign key.
The relationship is one to many...GeodataSetID is one and Attribute.GeoDataSetID is many

 

[dhookom]

And what are your results after "You would have to get rid of the GROUP BY"?

And what is your response to my earlier suggestion "You may need to use a join that displays all of the information from GeoData"?

czechmate55, if you want assistance, you must read replies from people who are attempting to help you and then respond to these suggestions. We can't see your screen. We don't know what you don't tell us.

Duane
Hook'D on Access
MS Access MVP

 

[czechmate55]

It works! I removed the Group By and I changed the join to display All GeoDataSet. I had it wrong and had it to display all Attributes.
Thank you very much for your help and patience.