Add Record

[pollenman]

Hi all,

I have created a button on my customers form to add an invoice, how do i keep focus against the chosen customer?

Regards

 

[TheAceMan1]

How are ya pollenman . . . .

Try:

[blue]Me.DataEntry = True[/blue]

I take it you've at least disabled the navigation button [blue]Add New[/blue], if not, whats the point?

See Ya! . . . . . .

 

[pollenman]

Sorry, where do i but that code

 

[TheAceMan1]

pollenman . . . . .

I should have asked questions first So . . . . .

Is this a [blue]single form[/blue] or [blue]form with subform[/blue]?

See Ya! . . . . . .

 

[pollenman]

Morning The Ace man

Main - Customer
Sup form - Site

 

[TheAceMan1]

pollenman . . . . .

Forget the previous code. In your button add the following

[blue]DoCmd.RunCommand [purple]acCmdRecordsGoToNew[/purple][/blue]

See Ya! . . . . . .

 

[pollenman]

Getting there TheAceMan1 where do i put it in my button?

Thanks for your patience

Terry

 

[pollenman]

Just so there is no confusion.

Customer "Joe Bloggs" with customerID 5 (Autonumber)

all I want to do is press the command button ande it brings up an empty invoice for Joe Bloggs.

What is happening at the moment is that i click the button and it brings up the invoice for the first CustomerID 1

I hope this helps

Terry

 

[TheAceMan1]

pollenman . . . . .

Forgive me, I'm not making the greatest sense out of this.

You have a mainform [blue]Customer[/blue] with a subForm [blue]Site[/blue]. Are invoices on the main or subform?

See Ya! . . . . . .

 

[pollenman]

we will get there!!!

Yes Customer is main and site for that customer as a subform.

Terry

 

[TheAceMan1]

[blue]You have a mainform Customer with a subForm Site. [purple]Are invoices on the main or subform?[/purple][/blue]

See Ya! . . . . . .

 

[pollenman]

Customer is main form and i will be calling the invoice from the customer.

Terry