Recent content by mbrost

This is definitely the solution I'd recommend -- this took me 5 mins, she works perfectly :D :cool:

FIXED :) You need to put "" around the text field values to act as a regular double quote -- I was thrown for a loop since my serial number is a text field, but this value was all numbers. Well, maybe this will help any other newbies like me ;)

Hi all, I've searched for a solution, and the proposed solution didn't work for me. I am executing an SQL statement to insert values into a History table when deleting a value in a subform. Two of the 5 values are asking me for parameters when the SQL executes and I cant figure out why! The...

Awesome thanks, that worked :D So, now I guess it's as simple as linking the Machine subform to the txtLink field?? I'll give it a shot. edit: This 2nd part worked too -- whoo hoo -- thanks again RuralGuy, you're a life saver! Mike

Still doesn't work for me, I have it laid out as you instructed. I did attach the DB -- the Form is frmAccount, the txtLink is in red and the subform it should reference is right above it called "Customer Addresses". Can you see what the issue is?? Thanks again for any help! Mike

yes, typo -- whoops, they are the same name, just the _Sub part. I'll try the above then let you know how I make out :)

Does it matter if my Source Object and Name have the same name for that subform? the name for both is frmAccountAddresses_Sub. So, the text field on the frmAccount is mapped to frmAccountAddresses_SubObj.Form.AddressID the frmAccount has the 2 subforms on it: frmAccountAddresses_Sub...

I've given this a quick try, but am having difficulty mapping a text field on a form to have a value of the subform on it. I've given this txtLink's Control Source name of: frmAccountAddresses_Sub.Form.AddressID where "frmAccountAddresses_Sub" is the name of the subform where I want to...

Thanks for the tip RuralGuy, but that doesn't work -- Access wont allow me to type that path into the Link Master Fields -- you need to choose from a list only. Both subforms are based on queries, and I tried to put some logic in the WHERE clause of the Machine SubForm like: WHERE...

This has to be a simple solution for you gurus. I need to reset a CheckBox flag on a form after a business rule is carried out. I noticed the check box gives the value -1 for Checked, and 0 for Unchecked. So, when the box is checked, I want to clear it after carrying out a business rule. The...

bump -- anyone have an idea??

Hi, I'm not even sure if this is possible to do (I havn't found anything on the Net yet), but I have a Form displaying Customer information, and the vending machines that customer has. The main form (frmAccount) has 2 SubForms: 1) AddressSubForm (is a Datasheet), listing the many addresses the...

Good point Pat, thanks. I actually realized that yesterday, and am changing my Address to one to many -- its only a rare case that an address will have 2 accounts... I'll check your example too and respond if I have any more Q's. Thanks again, Mike

Hi, I am assuming Access cannot handle Many to Many relationships very well. I have an Account form ("MainForm") with an embedded SubForm that displays only the Account Address with suite number, street number, street name, street type. Account to Address is a Many to Many relationship. My...

This worked for me :) Thanks RV, Scott and others for taking the time to lend a hand to a useless newbie! Mike