New Data Entry allowed and accepted but not shown

[RobotMush]

I am working on a data base that records the name, addresses and other data for each individual entered. I can enter the data and it does show up the in the queries. However, it does not show up in the form made from those queries. Is there a switch that I need to check to make sure it is set properly?

Thank you for your help

RobotMush (Technical Users) - Self Taught

 

[fneily]

Do you enter the data directly into your table or use a form? If you are using a query as input it may not be updatable - but it wouldn't let you enter data anyway. After you enter the data, did you open the table and make sure it's there? When you run a query, are you sure it's on the outputted recordset - you actually see it? Then you feed just one query into a form and the record is not there? If you are combining query recordsets, you'll have to check every step and output to see where it disappears. It may not be matching against something.
Maybe someone else has seen this. I would need your tables and queries to follow the record.

 

[RobotMush]

>Do you enter the data directly into your table or use a >form?
I use a form built from 4 quiries. Name, Address, Phone, Church.

>After you enter the data, did you open the table and make >sure it's there?
Yes I did, and it is there.

>When you run a query, are you sure it's on the outputted >recordset
Don't know about a record set, but it is in the quiries that I use.

>I would need your tables and queries to follow the record

Sorry, I can't seem to cut and paste it.

Thank you for your help will see if I can create a word doc or spreadsheet that I can cut and paste to you.

RobotMush (Technical User)Self Taught

 

[fneily]

Don't know about a record set, but it is in the quiries that I use."
A recordset is a table or the output of a query. You say it's in your queries you use. Does this mean you see the record on each query's recordset(output)?
You say you built a form from 4 queries. This, to me, means you brought together the output of 4 queries in another query and built the form on that recordset. Is this correct?
If so, how are the queries related (how are they connected, through what field, what kind of join)?

"Name, Address, Phone, Church" are query names or fields in a table?

What is all the tables structures? And what do you want to produce?

 

[RobotMush]

>Does this mean you see the record on each query's >recordset (output)?
Yes, I see the data in the each individual Table and each individual query

>You say you built a form from 4 queries. This, to me, >means you brought together the output of 4 queries in >another query and built the form on that recordset. Is >this correct?
I used a Form Wizard and placed all 4 queries in the form, setting it up to show one complete record at a time.

>If so, how are the queries related (how are they >connected, through what field, what kind of join)?
I have the following tables created...
tblName, tblAddress, tblPhone and tblChurch
tblName the key field "Prime_ID" is used to attache the table to tblAddress, tblPhone and tblChurch that also have the key field called "Prime_ID"

>"Name, Address, Phone, Church" are query names or fields >in a table?
These are the base Names, if it is a table it is preceded by tbl. and if a query by qry... I.E. tblName and qryName

>What is all the tables structures? And what do you want to >produce?
What I am wanting to do is have the smallest amount of data in a database that can produce the larges amount of information. Isn't that what database are supposed to do?

Hope that helps, and thank you.

RobotMush (Technical User) Self Taught

 

[fneily]

Connected your queries through another query. Check that output for the record. You would then build a form off of that output.
"What is all the tables structures? And what do you want to produce?"
You gave me the table names - what are the fields for each table? The names trouble me. Why would you separate someone's name, their address and phone number?
Good answer for the last question, made me laugh. I meant, what will the final result look like, what will the record's fields be?
If you want, you can go to thread702-563868 scroll down and you'll find a way to contact me. You could then ZIP your database and send it to me.