value from 2 field joined in one field...( help designing form)

[shiro]

Hi again All,
This time I come with a question that maybe sounds strange.

I have 3 textboxes on form F1,let say TBL and TBH their data
type are numeric and also TBN with text data.Sample record.
TBL TBH TBN
0 3 H
1 9 R
2 0 L:

Now I want to return both of TBL and TBH values to textbox
TBS on form F2 and TBN value to TBK ,with condition
If TBK value Then TBS value :
H 3
R 1-9
L 2

specially for record number 2,how to make access nows,
the value is '1 untill 9' not '1 minus 9'? this is my first question.

And then I will have another textbox in form F2,let say TBD.
with condition.
If TBK value Then TBD value
H < 3 ( if over,font = Red )
R Between 1-9 ( if over or lower,font =
Red )
L > 2 ( if lower,font = red )

Perhaps, font = Red should be come from a conditional formatting.
Is it possible to be achieved.?
Please help to design my form. Thank's

 

[Jeanette Cunningham]

Hi again Shiro,
are you using OpenArgs to tell Form2 what values it needs to know for its
textboxes?

If not, if Form2 reading the values it needs from Form1 and both forms are
open at the same time?

Jeanette Cunningham

 

[Jeanette Cunningham]

Shiro,
the textbox for TBS must have a text data type
If access sees "1-9" it will think this is a word like apple or dog
If access sees 1-9 it will think 'take number 1 and subtract number 9 from
it

if forms!form1.txtTBK = "R" then
me.txtTBS = "1-9"
end if

How is your database going?
How many forms have we helped with now - it must be at least 3 or 4?
Hope you are enjoying learning how to code the forms.

Jeanette Cunningham

 

[Jeanette Cunningham]

Shiro,
for the conditional formatting,
in design view, select the control that is to be 'conditioned'
select Format > Conditional formatting from the menu bar at top of main
window
it's fairly easy to set up from there, you won't need to write any VBA code
to do this

Jeanette Cunningham

 

[shiro]

Unfortunately,
I event don't know about OpenArguments.And I havent't creating the form F2
yet.
I'm tracking the possibilities first.And about open the forms at the same
time, I prefer
to open it one by one,and retrieve the data's of form F1 through it's
query.But I'm still
have not any idea yet.

If TBS data type is text,and the TBD data type is numeric,does access will
not confuse
to compare the value in TBD with the TBS value.

The form F2 would be the key of my database form,if it done,I can say 90% of
databse
is finish.And this newsgroup has assisted me much.Much thank's to help me.

 

[shiro]

Yup,Ms Jeanette.I've got that.
But my form would you suggest me more

 

[Jeanette Cunningham]

Shiro,
--forget about OpenArgs
--for what you have described, you will need form1 open at the same time as
form2
--you can hide form1 by setting its visible property to false
--you can still read the values from its textboxes
--access won't be able to compare a text data type with a numeric data type,
however it doesn't look like that's what you are doing
--it looks as if you are using the value of TBK to set the formatting for
TBD

Jeanette Cunningham