Recent content by cardgunner

Well I found an solution to Issue2 thru some feedback by Big Jon Booty He had another solution to that I didn't use. you can find the thread here http://www.access-programmers.co.uk/forums/showthread.php?t=210006 This also inadvertenly fixed Issue #1. No more error.

This worked great. Thank you very much.

Well when I tab out of field other it's supposed to go to field alt_id but it goes to the next field in the tab order. I'm trying to solve an issue I have in a subform where I don't want to go to the next record. I have posted the db and my issues here...

I have tried to do this but it doesn't work. My code on the lostfocus event is Private Sub other_LostFocus() Me.alt_id.SetFocus End Sub

Well I am getting close but not happy. I have created a db where the user will enter who has come to our open house. I created a form for customers that we currently have and another form for new customers. The current customer form, [frm_current_register] is fine. It works how I want it to...

Thank you. Yes I could, and I might have to. I have been trying different things for days now. I wanted to keep the user on one form. If I can't get a workable solution that keeps them on one form I will add a command button that will open a form where they enter will enter the corrected...

If it was that simple I would do that. But what about new businesses? What about the corrections to the existing businesses? What about addition info of an existing businesses gathered at the open house? If only existing business where coming it would be alot easier.

I have been given the task to create a db for our open house where we can record who shows up. We have our current businesses[extend_names], new bussinesses or corrections to be made to our current bussinesses[2011_attendee] and the contacts for both[2011_attendee_contacts] When someone...

I created a unique identifier. In the query I combined the 2 fields together as the unique identifier. that has solved that. Thank you.

In my form a have a combo box. I want 2 text fields to show the column 0 value and the column 4 value of the combobox. I have set the control source of the text boxes to =[Combobox_name].[Column](0) and =[combobox_name].[Column](4). This works untill I have selected a record in my combobox where...

Here is what I have upto now.

Hmmm. Maybe I'm not doing this right then. I think I need to start from scratch on this one. On the main form I have a combobox that stores the bpid of the selected record. I linked that value to my 1st subform to give me a set of records. That subform is uneditable. This subform1 is using...

I think I know the issue which is what you have stated. In my main form is a combo box where I find the record I want and select it. That box shows the [name] field but holds the [bpid] field. the subform looks at that and brings into it that record. I need to add(and hide) the alt_id field in...

Well the form and subform share the same recordsource, which is a Union query. And the bpid and alt id are in the same record, different fields.

Even the labels won't show?