By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Combining Fields

P: n/a
DS
I have a Combo Box (Fiield 2 is the seen one, field 1 is the bound one)
and I want to combine it with another field on a report. The new field
should only be visible whenever the Amount field is greater than 0.
How would I accomplish this?
Thanks
DS
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Tue, 14 Dec 2004 10:04:57 -0500, DS <bo******@optonline.net> wrote:
I have a Combo Box (Fiield 2 is the seen one, field 1 is the bound one)
and I want to combine it with another field on a report. The new field
should only be visible whenever the Amount field is greater than 0.
How would I accomplish this?
Thanks
DS

Hi
This is not very clear.
Since a space is invisible, you can set a control to have the
controlsource
=iif([Amount]>0, xxxx, " ")
where xxx is whatever you want to be visible.
David

Nov 13 '05 #2

P: n/a
DS
David Schofield wrote:
On Tue, 14 Dec 2004 10:04:57 -0500, DS <bo******@optonline.net> wrote:

I have a Combo Box (Fiield 2 is the seen one, field 1 is the bound one)
and I want to combine it with another field on a report. The new field
should only be visible whenever the Amount field is greater than 0.
How would I accomplish this?
Thanks
DS


Hi
This is not very clear.
Since a space is invisible, you can set a control to have the
controlsource
=iif([Amount]>0, xxxx, " ")
where xxx is whatever you want to be visible.
David

What it is, is this. The first field is a combo box that yields a
percent number, 10%, 15% etc. The second field is a field that says,
Family Discount, Manager Discount, etc. Also a combo box, both boxes
are bound to field 1 and display field 2. What I want to do is a third
field, unbound that would give me the result of field 1 and 2 combined.
Example: Family Discount 10%, Manager Discount 10%, etc. If there
is no percentage Family Discount, Manager Discount etc...there are
several combinations but that shouldn't matter.
Thanks DS
Nov 13 '05 #3

P: n/a
How about setting the form's On Current event to something like
ComboBox3 = ComboBox2.Column(1) & " " & ComboBox1.Column(1)

Column counts start at 0 so column 1 is the 2nd column. You can also
include some code to check if either of the ComboBox fields are null
before populating ComboBox3.

Hope this helps ... Good luck!!

Nov 13 '05 #4

P: n/a
DS
Koontzie wrote:
How about setting the form's On Current event to something like
ComboBox3 = ComboBox2.Column(1) & " " & ComboBox1.Column(1)

Column counts start at 0 so column 1 is the 2nd column. You can also
include some code to check if either of the ComboBox fields are null
before populating ComboBox3.

Hope this helps ... Good luck!!

GOT IT!
Its Format([Discount P],"##%")

Thank You Once Again
DS
Nov 13 '05 #5

P: n/a
On 15 Dec 2004 11:56:07 -0800, "Koontzie" <cr******@shbm.com> wrote:
How about setting the form's On Current event to something like
ComboBox3 = ComboBox2.Column(1) & " " & ComboBox1.Column(1)

Column counts start at 0 so column 1 is the 2nd column. You can also
include some code to check if either of the ComboBox fields are null
before populating ComboBox3.

Hope this helps ... Good luck!!

Is this on a form or a report? On a form you would need to also put
this code in the afterupdate event of each of the combo boxes
David

Nov 13 '05 #6

P: n/a
David Schofield wrote:
Is this on a form or a report? On a form you would need to also put
this code in the afterupdate event of each of the combo boxes
David


That draws my attention: if you want all controls on a form to share
certain behavior, you can see the WithEvents article on my site.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.