Need help forming an If-Then-Else Statement

[tlkng1]

Good morning...



Let's see if I can make this somewhat simple

1. I have four data fields in a table; one is data type text (call it alpha); two others are data type number (call them bravo and charlie respectively) and field delta is data type number formatted as percent.

By written English type coding I need:

If alpha = "complete"
Then delta = 100%
Else delta = charlie divided by bravo *100

2. I need to link a field to a subsheet that brings up definitions. For example, if someone clicks on the field to enter information, in this case functional requirements (in form FR-001...), a subsheet opens up with a list of definitions; this is specifically referring to a list of functional requirements for system development. It isn't a drop-down to select list but just an information page so the person entering the data can make sure they are entering the proper functional requirement.

For examle, the functional requirements table reads (think columns)

Functional Requirement ...........................Description
FR-001............................................... ....System must do something

When the user clicks on the Functional Requirements Field in the database, this table with the definitions would open as a subsheet.

Thanks

[ranman256]

if using vb code on text boxs as user inputs:

if txtAlpha = "complete" then
   txtDelta = 1
else
   txtDelta = txtCharlie/txtBravo       'you said formated as % so youd use decimals
end if

if using a query to update all recs:
UPDATE tTable SET WHERE (((tTable.alpha)="Complete") AND ((tTable.delta)=1)) OR (((tTable.alpha)<>"Complete") AND ((tTable.delta)=[charlie]/[bravo]));