Calc Field that waits for input if one or more conditions are met

[JTKrol]

Hi,

I'm not sure how or the best way to do what I am trying to do?

I want to create a calculated field that If the employment type is FT Hourly or PT Hourly it will have a pop up screen for the Hourly Wage to be entered. If those criterion are not met it nulls the Hourly Wage field.

Thanks a ton!


Joe

[ranman256]

have the query pull only those hourly folks:
select [name],[Wage] from table where [EmpType]='pt hourly' or [EmpType]= ft hourly'
fill in the [wage] field.

if you want a 'popup', build a form that connects to this query , for users to fill.