Search record

[Boss]

Hi,

I have a small master table with fund and processer as two diff fields.

Fund Processor

abcd JOhn
pitd Kevin
aw88 Steve


All i need is to track which fund was processed by whom. I am looking for a
form with two text box. I write the fund name in first it should
automatically show me processor name in second.

I tried a select query with fund as parameter but it didnt solved the
purpose. Alos to note it should only give read only access. it should not
make any changes in the master table.

Probably a dlookup can work, i tried that but failed.

Please help me... Thanks a lot...

Boss

 

[John W. Vinson]

Hi,

I have a small master table with fund and processer as two diff fields.

Fund Processor

abcd JOhn
pitd Kevin
aw88 Steve


All i need is to track which fund was processed by whom. I am looking for a
form with two text box. I write the fund name in first it should
automatically show me processor name in second.

I tried a select query with fund as parameter but it didnt solved the
purpose. Alos to note it should only give read only access. it should not
make any changes in the master table.

I would suggest that the simplest way to do this would be to have an unbound
form. Create a Form with nothing in its Recordsource (if you are asked what
table or query, leave it blank).

On the form put a Combo Box using

SELECT [Fund], [Processor] FROM yourtable ORDER BY Fund;

as its RowSource property; set the Column Count to 2 to include both fields,
but set the Column Widths property to

1.0";0"

to display the fund but conceal the processor. Name the combo box cboFund.

Put a textbox on the form with a control source

=cboFund.Column(1)

to display the second column (it's zero based) - the processor.

 

[Boss]

This worked the way I requested...!!

Thanks a lot.. John !!


This community has allways helped me learn.
THANKS TO ALL !!

Boss

Hi,

I have a small master table with fund and processer as two diff fields.

Fund Processor

abcd JOhn
pitd Kevin
aw88 Steve


All i need is to track which fund was processed by whom. I am looking for a
form with two text box. I write the fund name in first it should
automatically show me processor name in second.

I tried a select query with fund as parameter but it didnt solved the
purpose. Alos to note it should only give read only access. it should not
make any changes in the master table.

I would suggest that the simplest way to do this would be to have an unbound
form. Create a Form with nothing in its Recordsource (if you are asked what
table or query, leave it blank).

On the form put a Combo Box using

SELECT [Fund], [Processor] FROM yourtable ORDER BY Fund;

as its RowSource property; set the Column Count to 2 to include both fields,
but set the Column Widths property to

1.0";0"

to display the fund but conceal the processor. Name the combo box cboFund.

Put a textbox on the form with a control source

=cboFund.Column(1)

to display the second column (it's zero based) - the processor.