Subform datasheet not working

[Chris O''''Neill]

I have a form (Expense) that has a subform (ExpenseDetails) where frmExpense
shows the header info (VendorName, ExpenseID, etc. all stored in tblExpense)
and fsub ExpenseDetails shows all the transactions (AccountNum, DebitAmount,
etc. all stored in tblExpenseDetails). frmExpense is set to only allow
singleform view and ExpenseDetails only allows datasheet view.

When frmExpense loads fsubExpenseDetails starts to load but appears to
"hang" somehow. Only the last line on fsubExpenseDetails is listed until I
either click in each field (then that field displays) or click to another
record and click back. Also, new records cannot be entered into the
datasheet, even once it is displalying properly.

I have checked to be sure that both frmExpense and fsubExpenseDetails are
set to enabled and NOT locked, including all of the controls. I've also
compared these forms to other ones that I'm doing (frmIncome and
fsubIncomeDetails for instance), and can't see any differences.

In other words, I'm stuck! Any suggestions on what I should be looking
for?

Thanks!

Regards, Chris

 

[strive4peace]

Hi Chris,

I suspect that you put criteria in a query that you used as a
Recordsource for fsub ExpenseDetails ...

instead of using criteria in a query, use:

LinkMasterFields
LinkchildFields

for the subform control

for more explanation, read the main form/subform section in Access Basics

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

Warm Regards,
Crystal

remote programming and training

*
have an awesome day
*

 

[Chris O''''Neill]

Thank you, Crystal, for the suggestion. However, I wasn't using a query in
the subform but, rather, the LinkMasterFields/LinkChildFields properties as
you pointed out. I'm not sure what was causing the problem, as I looked long
and hard for what might be causing it. Last night, out of frustration, I
deleted the subform and started over. The new subform works flawlessly, so
although I never found the problem I apparently found the solution.

Thanks, again, for your adivce...

Regards, Chris

 

[strive4peace]

you're welcome, Chris glad you got it!

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*