In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the subform.
I added a field to my table, and modified the design of my subform. Now,
data is not getting displayed on the subform for any form records. I did
not change any properties.
I'm on XP Pro and using MS Office 2000 Pro.
Thanks for any help you can give me. 2 1805
Scott wrote: In my database, I have a form with a subform. I had everything working correctly - the correct records would display on the subform for each record on the form. I could edit, add, and delete on the subform.
I added a field to my table, and modified the design of my subform. Now, data is not getting displayed on the subform for any form records. I did not change any properties.
I'm on XP Pro and using MS Office 2000 Pro.
Thanks for any help you can give me.
Is the form build on a table or query? If query, is there the
possibility a relation was reset or deleted...example an inner join
pointing to the wrong field in the table to be related?
Can you open the subform by itself and display records?
Did the properties change on the link? Click on the subform area when
modifiying the main form in design mode and pull up the property sheet
and check the Master and Child links. Are they correct?
Is it possible all of the data in the child table is gone.
Lastly, reboot.
I was not able to display the subform by itself with the data, so I then
ruled out it being a link problem. But, I had checked my link properties and
those looked correct. The data from the table still existed. Rebooting did
not fix it.
I was finally able to figure it out and I had the data entry property set to
yes.
Thanks for your help.
"Salad" <oi*@vinegar.com> wrote in message
news:yr******************@newsread1.news.pas.earth link.net... Scott wrote:
In my database, I have a form with a subform. I had everything working correctly - the correct records would display on the subform for each record on the form. I could edit, add, and delete on the subform.
I added a field to my table, and modified the design of my subform. Now, data is not getting displayed on the subform for any form records. I did not change any properties.
I'm on XP Pro and using MS Office 2000 Pro.
Thanks for any help you can give me. Is the form build on a table or query? If query, is there the possibility a relation was reset or deleted...example an inner join pointing to the wrong field in the table to be related?
Can you open the subform by itself and display records?
Did the properties change on the link? Click on the subform area when modifiying the main form in design mode and pull up the property sheet and check the Master and Child links. Are they correct?
Is it possible all of the data in the child table is gone.
Lastly, reboot. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Rey |
last post by:
Howdy all.
Appreciate your help with several problems I'm having:
I'm trying to determine if the Visit subform (subformVisits) has a new
record or been changed, i.e. dirty. The form that...
|
by: Maggieanp22 |
last post by:
I'm designing a db which stores client details but each client has multiple
'occasions'. For each occasion there is a section which has items purchased
(there are sometimes none, sometimes...
|
by: wayne dooley |
last post by:
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform
to show those in SUBS. The 2 tables are related...
|
by: Scott |
last post by:
In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the...
|
by: Nicolae Fieraru |
last post by:
Hi All,
I have a problem and I can't figure out how to solve it.
My database has three tables:
tblCustomers, with CustomerId and CustomerName
tblProducts, with ProductId and ProductCode...
|
by: google |
last post by:
I have a form with several subforms. Users enter the data, then on the
parent there is a command button that runs code to generate a .pdf
document from a report based on the data they are working...
|
by: Ecohouse |
last post by:
I have a main form with two subforms. The first subform has the child
link to the main form identity key.
subform1 - Master Field: SK
Child Field: TrainingMasterSK
The second subform has a...
|
by: wwwords |
last post by:
I have a form in Access 2007 containing a subform. The control source
of the latter is
SELECT DISTINCTROW ., ., ., .,
. FROM ;
which is undoubtedly correct.
However, if I click on the down...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |