Search results

oh thank god i got it working some how....

lol meant unbound control not bound form

could i get the data in vba and stick it to a bound form? while where on it, what object defines the "current" recordset being used at a given time? i know how to load a recordset but if your working on a subform i assume the current recordset and its current position is already available...

god how do i fix that now? data in there aready won't that stuff things??? surely there is a way to show the text not lineID?

sorry try this...

yes all the same query. the field "BillByType" will not display values in subform but in query fine - the field is there in sub form but blank... query subform

Have you check the control's source to be sure it is bound th the correct field? yeah...it is. since it links to table the ControlSource is BillByType from the query it comes from a list table so the row source is SELECT [tblBillingTypeCode].[LineID], [tblBillingTypeCode].[BillType] FROM...

ok...i have query which brings 2 tables together. works great. go to load as subform and every field displays except 1!!! its there but the records look empty in that field - i open seperately and they are there, just not in subform! any thoughts?

cheers! good to know

got a simple list with a form, users cycle through with record selectors as per usual no need for vba for the most part - however.... whats the best way to track and influence a new record? how do i tell its a "new" record at the end of the set if i''m looking from the OnCurrent event? (i...

i added to your rep buddy

and the ' helped too! you rock!

that was it i'm a dunce your a legend...etc etc!!!

well the first 2 toggle controls so true/false really.

ok i have a sub that is designed to get data from a form and filter a report from the user choice. i need to the docmd object to accept multiple where clause which are built from vba. NOW i know there are some fields with spaces (bad bad! me) but this thing evolved over a long time and i was...

he was hired as a contractor and bought his own computer. why he bought mac before discussing it, NO IDEA!!! i am in windows partition. i think. honestly u have raised some questions i'll have to go check out and get back to u....

Thanks bro!

it boots windows flat out, not virtual. i think. um. well how could u tell really. but it works from boot menu not a window inside the mac....

gee thanks. it's running windows i had high hopes it would act like it....

nah now i've got it to another stage....aarrrrgh! trying to get multiuser access going working on 2 machines, but the third opens and read only even with no other computers online! annoying. the problem computer is a mac running windows, it's also about 100 times slower than the imb/pc machines...