ms access sub from value to main form

[mabino79]

1- =[tblInventoryTransactionSubForm].[Form]![Text83]

getting error on this

2- also want to know that is it possible to make like data validation in excel.

if possible can create error or pop up windows on validation.

 

[mabino79]

sub form value required to be on main form only total, giving error with above.

please suggest.

 

[Gasman]

Please do not crosspost/start the same question again. You have many replies in your other thread https://www.access-programmers.co.u...-main-form-from-sub-form-transactions.319949/

 

[mabino79]

Please do not crosspost/start the same question again. You have many replies in your other thread https://www.access-programmers.co.u...-main-form-from-sub-form-transactions.319949/

please help to resolve the issue.

 

[Gasman]

I have told you the syntax.?
Upload a DB and explain how to get to the problem. However I only have 2007, so might not be able to open it.
Upload it in the other thread though.

 

[mabino79]

I have told you the syntax.?
Upload a DB and explain how to get to the problem. However I only have 2007, so might not be able to open it.
Upload it in the other thread though.

OK

 

[mike60smart]

Why have you got the following Calculated field in tblInventoryTransaction?

IIf([TransactionType]="1",[Qty],-[Qty])

 

[Gasman]

Probably trying to make qty negative if transactiontype not =1 ?

 

[oleronesoftwares]

2- also want to know that is it possible to make like data validation in excel.

yes, using the following properties
1. Validation rule
2. Validation text

 

[mike60smart]

Relationship Diagram does not look right to me either.

 

[Minty]

@oleronesoftwares - That's not how validation works in Excel, I think the OP means a lookup list as in a combobox of valid entries.

 

[oleronesoftwares]

@Minty ,@mabino79 , above is an excel validation dialog box, with labels(replicating similar thing in ms access)

 

[Minty]

@oleronesoftwares I think I might have known that...
If you use it in Excel will present a Combobox of valid entries. Access validation rules at a table or form level won't do that, it's completely different.

 

[oleronesoftwares]

@Minty, maybe am not understanding what the OP wants, i await more clarification from him/she.

 

[Minty]

@Minty, maybe am not understanding what the OP wants, i await more clarification from him/she.

Perhaps if you aren't clear refrain from commenting until you are?

 

[oleronesoftwares]

Perhaps if you aren't clear refrain from commenting until you are?

Advice noted, but as I wrote earlier, let's wait for the OP to make confirmation.

 

[Minty]

See - another comment that adds nothing to the thread, and just obfuscates the responses that provide answers.
Not being rude, but personally, I would refrain from commenting on every thread, unless you are contributing an active answer.

 

[mabino79]

i want to make a validation rule on Sub form value should be reflecting on main form if the value goes below 0, it will give popup on entering the values for the same.

i hope m clear to understand my query, if not please let me know.

thanks.

 

[oleronesoftwares]

i want to make a validation rule on Sub form value

This is clear, example of validation rule is needed.

should be reflecting on main form if the value goes below 0

Not clear.

it will give popup on entering the values for the same.

Is it when entering values in the subform control, or the main form?

 

[mabino79]

This is clear, example of validation rule is needed.


Not clear.


Is it when entering values in the subform control, or the main form?

yes