Table Field with IIf and Data Entry

[karl009]

Hi,

I have a table with a felid that is called QtyCI, I need this field to be multi purpose.

First it needs to perform an IIf statement;

IIf([MBSTQT]>99999,"STOCK","003")

Then if needed it needs to be typed over and data entered into the field.

Can this be done or it best to have them separate?

Thanks

 

[Brianwarnock]

First things first
Never enter data directly into a table. Tables are for storing the data, the data is entered via a form, read with queries and viewed via Forms or reports based on those queries.

Don't really understand about the field being multi functional, all fields conatin a variety of values, but don't think they should be multi functional, what's the benefit?

Brian

 

[vbaInet]

I think the second question is referring to also being able to enter data into the lookup control. There's a way but I don't see how that would be useful karl009?

 

[karl009]

Hi,

The Database is being built up from an Excel spreadsheet and they have there formula in there which I have done the Access equivalent, but they also over write the formula with there own data in the spreadsheet.

This is what am trying to mimic.

Thanks

 

[vbaInet]

Well Brian has already advised you not to use tables for data entry. If you are going to use a form then there's a way.

 

[karl009]

Hi,

I will be using forms once I have sorted out the Tables and Queries.

An example of how this is done in a form with me very helpful.

Thanks

 

[vbaInet]

Still curious why you want to do that? It may lead to problems.

FYI: It would require changing the control source and Text of the control using the Lost Focus and Got Focus events.

 

[karl009]

Thanks vbaInet,

I will have a look at that when I come to do the forms, but it might be best to have a separate field for the data to be entered and the expression in the query for my IIf statement.

Thanks

 

[vbaInet]

You're welcome!

..., but it might be best to have a separate field for the data to be entered and the expression in the query for my IIf statement.

Exactly what I was thinking karl009. Better way of doing it.