473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Subform going completely blank

Hello,

I have a main form with one subform. The main form displays a record from
TableOne (PCID)

This is a corporate software tracking utility that works like this:

Main form...Choose PCID (from TableOne)
Subform..Display / Add software (from TableTwo) (linked via PCID)

Relationships:
TableOne(PCID) linked to TableTwo(PCID)
TableThree(SoftwareTitleKey) linked to TableTwo(SoftwareTitleKey)

The Subform displays query data from TableTwo based on the choosen record
(PCID) in the main form.
My problem is, after I add a new PC into TableOne in the main form, the
subform goes completely blank until I manually enter at least one record
into TableTwo by editing TableTwo directly.

Why does my subform go completely blank if there is no linked record yet in
TableTwo? Even my data entry fields and buttons dissapear which doesn't
allow me to enter the first record into TableTwo.

Thanks

Tim
Nov 13 '05 #1
1 6491
The Detail section of the form goes completely blank if both:
a) there are no records, and
b) no new records can be added.

The 2nd condition can be caused by setting the form's AllowAdditions
property to Yes, or if the form's RecordSource is a query where new records
cannot be added.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:7B*******************@fe2.columbus.rr.com...
Hello,

I have a main form with one subform. The main form displays a record from
TableOne (PCID)

This is a corporate software tracking utility that works like this:

Main form...Choose PCID (from TableOne)
Subform..Display / Add software (from TableTwo) (linked via PCID)

Relationships:
TableOne(PCID) linked to TableTwo(PCID)
TableThree(SoftwareTitleKey) linked to TableTwo(SoftwareTitleKey)

The Subform displays query data from TableTwo based on the choosen record
(PCID) in the main form.
My problem is, after I add a new PC into TableOne in the main form, the
subform goes completely blank until I manually enter at least one record
into TableTwo by editing TableTwo directly.

Why does my subform go completely blank if there is no linked record yet
in
TableTwo? Even my data entry fields and buttons dissapear which doesn't
allow me to enter the first record into TableTwo.

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: Joe Scully | last post by:
Hi all, I am having trouble with access adding a blank record to a subform everytime I finish entering data and closing the form. (The form and subform are based on the one table) When...
3
by: Charlene | last post by:
I have an Invoice/Invoice Details form/subform. In the page footer of the Invoice Details subform I have a textbox with the control source set to =Sum(). I then pull this value into the main form...
25
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...
1
by: Tim Graichen | last post by:
I have FrmMain that has one subform (SbForm). FrmMain is filled with records from Tbl1. SbForm is filled with records from Tbl2 based on the current selected record in FrmMain from Tbl1. ...
5
by: Susan Bricker | last post by:
Hi. I have a Main form with a subform that has a subform. I have an 'Add Event' button on the Main Form that issues the following instruction: DoCmd.GoToRecord , , acNewRec If the record...
2
by: Shannan Casteel via AccessMonster.com | last post by:
I have a simple invoice form with a subform that allows the user to list part numbers along with the quantity. The subform has a calculated field called that should take either the or the and...
2
by: Mike | last post by:
I have a parent form with two subforms on it. Each subform lists certain records and then totals up one of the fieldsd. The parent form then totals up the two text boxes. The problem is that if...
9
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...
1
by: andrewbda | last post by:
I am having issues with showing a subform. Basically it is an address form, which is linked to a customer number on the main form. If there is an existing address record, the form always...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.