form help

[raven123]

I want am trying to do is in my form there will be a integer field numbers to exclusive forms. If someone was to go back into the form and re-edit it I DO NOT want the integer field to have to same number How would I go about writing this?
'
Here s my code

If A.Value="Martha" Then
TempEntBldValue = EntBld.Value ///integer field
EntBld.Value = TempEntBldValue
MsgBox "Invalid Value"
End if
End Sub

[opus]

I'd like to help, but you must give more details and use an understandable language!

[raven123]

okay here we go.
say i put a # in a field and then close it.
Nxt say I have to reopen the field to fix something, well the field that has the # field in it can not have the same integer that it had before the field ws reopened to be fixed


If Asgnto.Value="Martha" Then
TempEntBldValue = EntBld.Value //I put the integer into a temp folder
EntBld.Value = TempEntBldValue //here's where i want to compare the temp folder and the text field to make sure they don not = each other
MsgBox "Invalid Value" //here's where i alert the user that they can not have the same value
End if
End Sub

[opus]

What's the useof your EntBld.Value?
I think this will help, but I do not completly understand your problem.
If A.Value="Martha" Then
TempEntBldValue = EntBld.Value ///integer field
I think your EntBld.Value must get any kind of new information in here.???
if EntBld.Value = TempEntBldValue then
MsgBox "Invalid Value"
End if
End Sub

[raven123]

the EntBld.Value is the name of th field that holds the integer..does that help

[opus]

I think you have to use more specific code between:
'TempEntBldValue = EntBld.Value'
and
'if EntBld.Value = TempEntBldValue then
MsgBox "Invalid Value"
End if '

You store EntBld.Value into the TempEntBldValue, but I don't see where you get a new value for EntBld.Value. In your code both values remain the same, so the If..... will always be True.

[raven123]

a new integer is entered into the EntBld.Value when the form is reopen to be fixed. Then It should be compared in the temp to make sure they do not =

[opus]

Lt's see if I get it wrigth
while your in the form you perfom:
If A.Value="Martha" Then
TempEntBldValue = EntBld.Value

after coming back into the form again you want to perform this part:
if EntBld.Value = TempEntBldValue then
MsgBox "Invalid Value"
End if
End Sub

1. The value TempEntBldValue must be set as a public Variable (Dim shared.....), in order not to loose the value when leaving the SUB.
2. Both parts must be in differnet SUB's, the second can be called when reopening the form

Hope that's it

[raven123]

U got it. Thanx for you help!!

[deep]

Hi,
Is there any way, i can include a graphic and text in a rich text box control? When i add text to it, the graphic gets replaced by the text. Or is there any other control that i can use for this purpose. Please help...
-deep.