VBA to Python

[KTF]

In moving from using Access front end forms and code connected to an Access
back end I am looking at changing to Java front end to SQL back end with a
business rules engine using Python.

These are busy forms and there is a lot of data validation (checking data
input for correct format, string length etc), if this do that's, and
directing of drop-down list content based on the entry or selection of the
previous field (if this make, populate the next list with the models of the
chosen make etc).

Is Python a good choice to manage and run the rules and is there a way of
transcribing / translating the VBA code across to Python other than
literally doing it
line by line?

Thanks,
Keith